DSXchange

Thanks to every one for your valuable suggestions

Thanks for your quick reply

I got it now

Previously I did not copy from [EnvVarDefns] part in the file.

Just curious to know if there is any other way to copy Environment variable from Project to project

Thank you

Hello Gurus, I created a New Project and would like to copy User defined Environment Variable from other project. As Ray said i copied last lines in DSParams file and past in New Project. It did not work for me. Just copy those rows from DSParams that you need in the new project, and make sure that ...

Craig we using oracle release 9.2.0.2.0 for client

Craig - Yes, we have 9i and 10g client on datastage server and database is 10g.
we are using 9i client. how does this effect

I did not open the tickect yet but ill do it soon...

aaa

Craig - Yes, we have 9i and 10g client on datastage server and database is 10g.
we are using 9i client. how does this effect

I did not open the tickect yet but ill do it soon...
[/quote]

what is the Query that you are using to do a lookup. Paste both the query, user defined and Generated. ... custom SQL SELECT MRE_0003_MBR_ID_SITE,MRE_3001_MBR_ID_1_3,MRE_3001_MBR_ID_4_5,MRE_3001_MBR_ID_6_9,lpad(MRE_3001_MBR_SEQ_N,2,0) FROM CCI_hipdwstage1.MbrElg MbrElg WHERE MRE_0003_MBR_ID_SITE=:1...

Apology first I am really sorry I did not mean to say that even though it sounds like it. I did try reset. I did not get much info from that may be I missed, so I am going to paste Log reset messages DataStage Job 533 Phantom 24912 jobnotify: Unknown error [24937] DSD.StageRun full_MbrBill_Ld. full_...

There is no change in select statement. job will select all rows and finish with abort. I tried all the options in there every does the same except generated. i dont know whats trick....

Hello Guru's I would like to know if any one else faced similar problem and if yes please pass the solution. I did find some posts similar but not exact coming to the problem job fails at transformer stage due to abnormal termination at lookup and writes warring to log then aborts with core dump mes...

sorry i forgot add my question.

why is it different from project to project?

Hello, I am using crc32 function to calculate row value for type2 changes. I did crc32 on one data set in development project and used the same data set in UAT to do crc32. I expected both the values to be same but they are different. In short crc32 value in development is different from UAT for the...