Sorry to cut in.... just wondering... where can I download the SQL reporting services? 

David,

Don't hate me for this... but I'd like to enquire how you manage to insert?

I ahve the same config as you... but the only way I issue command is...

Thanks a zillion again.

Unfortunately I have no control over the iSERIES.  But anyway, I've passed the command to the administrator. 

Regarding the insert/delete command.... do I need to use the...

Funny..... Now it works... think after I set the setting, must wait for a while or must restart the connection... now it works!!

Thanks a zillion...

How about uploading?  Ever tried Delete...

Does not work.... Still same number of limited records

I think I'm using Client Access v5.1

So, for data transfer (especially from AS400 to SQL), I'm now using DTS.  At times I use a temporary table to first store the...

Erm... might not be useful but could it be due to the Network card? Just a guess cos I had the problem in the past when I was using a...

Hi

Sorry to drop by like that but that's interesting because I have the same problem.  The following is the query that I got from this forum

Select * from openQuery(IBMAS400, 'Select...

Just wondering...

Instead of deleting those "undesirable" characters, could we replace with a character of our choice? 

Hum.... how about replacing each undesirable character with another one (if defined) otherwise replaced...

Hi, not really the solution to your question.. but this is how we do it...

We have a table with the following:

TableName, CurrentNumber, EndNumber etc etc

We created 1 Procedure, taking the table...

Hum... I've created a simple procedure with

Alter Database XXXXX Set SINGLE_USER With Rollback Immediate  

Waitfor delay '00:00:30'

Alter Database XXXXX Set MULTI_USER With Rollback Immediate 

And it works when I scheduled it in...

That's one way to do it.  You are basically using "set identity_insert myidentity on" and then insert one row at a time, which is permissible.  I was hoping to insert...

How about not using the datetime type.  Could also send from Database... and using JavaScript (like Date Picker) to do all the formatting.....

Thanks for all the help... I tried a few times but can't seem to achieve anything.  Not too sure where to tweak the ODBC configuration.  I'm just hoping someone has...

"SHEAU.AA_CHEQUE" won't work....

I'll try the rest in a couple of hours after getting some sleep.

Talking about test table etc... Should I be worried that such "link" is permanent and could...