DSXchange

Hi, I reading a text file through schema file.My end of line character is \n.When I am specifying record_delim='\n' in schema file , records are getting rejected while reading.When i run cat -e -v <<filename>> I can see \n$ as the last character.What option should i specify as record_delim?

Load method is append in both the jobs.

Hi, Till now I was of the opinion that two different parallel jobs loading the same table in database cannot run simultaneoulsy.But today, I saw two parallel jobs(DS v8.5.1) loading the same table simultaneoulsy.The target stage was Oracle connector.Am I missing something? Can anyone explain this be...

Why do you want to abort the job via sequential stage?You can do the same using a transformer stage next to sequential stage.

Thanks Phil for you inputs. I have specified the partitioning as db2 connector in db2 connector stage where I have put update and insert mode.Also the table I am loading is partitioned table.As far as nulls are concerned, I have rejected them through transformer stage just before upserting them to t...

While using the option as upsert(update then insert) in db2 connector stage (DataStage Parallel Version 8.5), is it possible that records will be rejected if we have duplicate data in the source? Ideally everything from source should be updated even if we have duplicates..

Did u try the formating option New Style Line: Unix(LF) or DOS(CR/LF) in Output Properties tab

Are you viewing it with browser or notepad?

Are you viewing it with browser or notepad?

Hi any updates on the above. Even i'm looking for a solution

Thanks for your reply guys. Is there any means to send a message to IBM so that they can fix this. And please refer to this link. they have mentioned of exporting routines http://www-01.ibm.com/support/docview.wss?uid=swg1JR31326 @chullet I was not sure that this message has been posted. Hence did i...

Hi could anybody tell me the command prompt to export routines.
i tried dsexport.exe <host> <user> <password> <jobname> <targetpath/jobname.dsx>

It exports datastage jobs but i wanted to do the same for routines as well.
thanks in advance

Hi all, i am able to export the datastage jobs without dependent items with the command prompt from this post. but what change has to be made to the command prompt to export jobs and routines. when i tried it is failing to export throwing a message like no job with the name exists.

Thanks Ray. Where can i find the performance comparison of both the stages? Enterprise vs connector.

Glad to see your answers. Where can i find the details of the backend changes made by IBM to bring in the connector stage?

My another query is in Datastage 8 we have ODBC enterprise as well as ODBC connector stage. how do we decide upon the selection of the stage?