DSXchange

I changed it to
SET IDENTITY_INSERT STTLMNT_PRCS ON;

but I am getting the exact same error !

I am doing SQL server table from Database A to SQl server table in Database B Getting this warning and job gets aborted. DataStage][SQL Client][ODBC][IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'STTLMNT_PRCS' when IDENTITY_INSERT...

I changed a column type from Integer to Decimal for SQl table A Source & SQL table B Target 1st I changed the table definations for both tables [Integer to Decimal] 2nd I manually typed inside the transfomer for both [Integer to Decimal] I am getting this warning now: (componentNumericValue) gav...

I have a excel file with column [Names](names in it). I am sending this file to target SQL 2005 table with column [Names] (names in it) varchar 64. In the transformer: XLS [Names] had varchar 244 | SQL [Names] has varchar 64 I changed XLS to varchar 64 Now if I add a new name to the XLS. DataStage w...

I dont need the whole script but I could not find much info on how to run a dsjob using perl thats why, I posted a message.

(This is not an exam or a test that u cant help each other. This forum is to give or get help no restrictions on the degree of help !)

I created a job but it needs to be started only with a Perl script on a windows server. How do I do that. (Never used Perl)

Please help ...

anbu wrote:Load CSV file into hash file. Use the hash file for lookup

after converting to hash file

how can i read which party paid who ?
i mean how can i seperate that as the data i am getting is like a string only seperated by commas such as (payfrom= john, payto= jill, amount=100)


thanks

I am using DS 8.1 server. I have a CSV file with data such as below: from=jack, ac= 12345, to= jill, amount= 123. from this comma seperated string i need to look up from = person name & to = person name. i have a separate table with names to lookup from i need to find out who is paying to who &a...

I was talking to someone and I am not exactly sure if I am right:

1st came IBM InfoSphere 8.0
2nd IBM WebSphere 8.1

Correct ?

Which one came 1st WebSphere or InfoSphere ?

Also can you name some important ones along with version numbers ?

Thanks

A basic Question.

Starting from the 1st to latest what are the different versions of DataStage.

Ascential DataStage (v ?) -> WebSphere 8.0 -> InfoSphere 8.1

Can anyone elaborate/correct ?

Gracias.



**Note: Title changed to reflect actual topic - Content Editor **