DSXchange

Some rows are getting dropped before inserted into the target table with the below warning. LimitedCust..tmfCust.InsertCust: DSD.BCIPut call to OCONV failed. Column: Description, NLS mapname: MS1252, Column data (after conversion): Clothes issue: 62082-04BOL?edition # 82 of 200 leaking , Column data...

Whats your buffer size and I presume your SQLType is LongVarChar-9999999

Look at this link !


viewtopic.php?t=87824&highlight=vertical+pivot

Thanks,

Hi All,

Sorry for the delay.

Chulet -- SQL Server with DRS set to ODBC.

Meena-- Yes I am doing this in two jobs


Ray -- This is ASCII and Binary Data. NLS is set to ISO8859-1

Pls let me know if you need more inputs...

Thanks,

Hello All, I am trying to understand this DRS stage-- I am doing a view data. I can see the data for all the columns except for the columns with binary Datatype. For these columns I see junk data when viewd through datastage. Whereas when I view the same data through ODBC Stage I can see all the dat...

I dont know if Raj could crack down his issue. We faced similar problem when all of a sudden couple of jobs extracting from db2 source starting to hang. Nothing was getting extracted and we had to kill all the processes first to make sure there were no locks and then the jobs started working fine ag...

Our OS is Windows. I am assuming yours is on Unix and im not sure about what all are needed in ODBC.ini . May be you need to browse through the forum for some really useful tips.

http://dsxchange.com/viewtopic.php?t=93 ... 1c434fbdc9

HTH

I just got a breakthrough. I had a connection open to AS400 which was not killed and I was trying to view the data again and again which made it worse. I had to close my DataStage client and then kill all the connections I had to AS400 and then try and it worked.

Thanks,

Hi All, Each developer logs on to DataStage client with their own profile. Then they connect to AS400 using ODBC with a generic profile which all developers can use. I am unable to connect to AS400 while others can.Is there an issue with my profile to connect to DataStage as I cant see an issue with...

Thanks DSGuru2B and loveojha2 ! that will work.

Hi All, I want to handle when a job activity fails or finished with warnings in a sequence. Though the checkbox is checked against "Add checkpoint so sequence is restartable on failure" , I know it needs the job to abort, to re run from the failure point. I do want rerun the jobs that have...

Yes Guru, Looks like we are close. I need to identify among all the records which two records have same key, how do I do that here...

Thums

Thanks for your response. Say we have 2 records with the same key from source Customer ID 1000 1000 Now if we do a hash and we dont find them in Target. Both these records go as Inserts, but I need to make one of them Active and the other as Inactive in the target, Pls let me know if you need more i...

Chulet, In a situation where we have 2 same records with the same natural keys say consumer name. Rec1 comes , you update the existing target record with EffEndDate -- StartDate-1 of new record Rec2 comes, update the target record with EffDate--StartDate-1 Both the records go to insert but then I do...

You are right !! I have to create a DSN on the DataStage server. I have asked my DBA to do it as I dont have an access to it.

Thanks you all,

Thums !!