DSXchange

reddy,

not updating correctly

? Does this mean when you enter a "3" it actually updates a "7"? Or that records are being deleted instead of inserted? Or that updates are not being performed? You will need to tell us a bit more...

mat, is this a problem with the table as a whole or with a specific value in a row? In the first case you will need to set the NLS for the job as a whole and in the latter it might mean that a character has shown up in the table which cannot be mapped into the target character set. So, where and how...

Sorry, I was being a typical consultant - I answered your question but didn't help you at all :D You need to use DataStage routines to call jobs from routines. 1. DSAttachJob() to "open" the job for use 2. DSPrepare() [optional] to prepare a perhaps aborted job 3. DSSetParam() [optional] to set para...

Yes, you can run jobs easily from routines.

Memrinal, this is covered in detail in the documentation of DataStage. Please refer to the Administrator Guide. Page 3-2 is a good starting point. There are 3 user types in DataStage with defined roles: 1. Developers 2. Administrators 3. Operators. more juicy details in the documentation and through...

No, it cannot.

Done from the client system, the compile looks like this to compile all the routines in a given project. You can look at the help to get the options you are looking for:

"C:\Program Files\Ascential\DataStage7.5\dscc.exe" /h {server} /u {userid} /p {password} /r * {project}

try adding "-mode normal -wait" to the command line. Also, is your job compiled and runnable?

Aravind, if you have the same or similar version of DataStage that I do (7.5.1) then the corrupt file is either DS_CONTAINERS or DS_JOBOBJECTS; but it could be one of several other files. This is pretty serious corruption; so instead of trying to repair the error shown I would ask what could have ca...

snassimr,

in the Designer, if you do a "View Data" on the hash file do you get prompted to fill in the value of the parameter?

Is "NUMBER" your parameter - remember that parameters are case sensitive.

Lance,

I used "null" in that line and it worked with my test data.

lclapp,

normally the sequential file should be faster as there is much less processing going on in the background. The fastest method would be to not land the data on disk at all, going straight to the output stage writing to DB/2 --> what errors do you get when you try this?

Gop, this is not a "frequently asked question" and doesn't belong in this forum. DataStage uses the end-of-record delimiter on delimited (non-fixed-length) files to switch to the next record, so the number of columns isn't necessary to get record data. You can specify in datastage what to do for eac...

Lance,

which stage are you referring to?