DSXchange

I tried once to unlock a job and it worked fine. But the second time i am not able to go in with the same commands. What i did was 1. Logged in as dsadm 2. went to DataStage home directory. 3. Entered ". ./dsenv" 4. Entered "bin/uvsh". 5. TCL prompt came 6. Entered "LIST.READU EVERY" at TCL 7. Ente...

If it contains a single column, why do you mention "the first few columns"? Do you mean "the first few rows"? That some rows are getting through suggests that the FTP mechanism is intact - you will need to do some detective work to determine why only a few rows. For example: Can you FTP the entire f...

Search your sources WHERE colname IS NULL.
If the source is a text file, use the format tab or individual column properties to change the representation of NULL.

I answered the original question. A specific answer to the first part of the second question is to concatenate a zero character. Convert("MF", "12", InLink.Gender) : "0" To decode "M" to "Male" and "F" to "Female" can be done with multiple Ereplace() or Change()...

It is not an NLS error. It is just reporting that there are no characters than can be mapped. The file is empty. The rest follows.
Provide a default value for the date column; the empty string (because there are no rows) is not a valid date.

The raw data reported in the error message has 0x0d as its final character. This is a line feed, which probably means that you have specified the wrong termination character in your stage properties, or that there is a line feed character (or short row) in your data. "Putting it in a temp file" has ...

Have you tried trimming @FM as well as white space from the output? DataStage converts line termination characters into field marks.

Convert() performs a character-by-character conversion. In your specific case,

Have you actually tested with an encrypted parameter? That aside, if DSGetParamInfo(hJob, paramname, DSJ.PARAMVALUE) and DSSetParam(hJob, paramname, paramvalue) can handle encrypted parameters, then it ought to be possible to create another routine - somewhat a clone of UtilityRunJob - to run the jo...

Use the same user ID in DataStage that you use in TOAD.

Please let me know is data stage will run in windows environment?, Yes if it works both client and server will work? Yes. Many IBM classes are taught on this configuration. If yes please explain how they run px jobs in windows environment, The same way as on UNIX machines, via osh (osh.exe) and whe...

DataStage is documented as not being able to be installed on a symbolic link. It must therefore depend on the relationship between the DataStage server machine and the SAN; how SAN-disk "file systems" are mounted on the UNIX machine. It may prove completely impossible. This still does not preclude a...

If you post the name of the company interviewing you, someone here may be aware of their standard questions and expected answers.

Message handlers are only available for parallel jobs as far as I am aware. As to duplicate keys, all I can say is that your stored procedure certainly seems to believe that you are sending them - or that the SP itself is generating them. Have you checked its code?

The first error message seems to suggest that PWD is not set, or its value has been "lost" somehow. I suspect you've uncovered a bug, since it only occurs intermittently.