DSXchange

And if you write the date to a dataset what values are written (null or something else)?

No, it makes sense to do it after each lookup.

It would seem that "Units", "U_type" and "value" are not input columns, while "symbol" is.

Is this just a warning and the job runs correctly, or is it really an error disguised as a warning?

Jason, I'm sorry that you didn't get any responses on your first trip to DSXchange but welcome nonetheless. Most of the users of DSXchange are still at sites where Version 7 (and lower) is in use; there are not too many {large} sites implementing version 8 as of yet and most of the time the new inst...

Jason, I'm sorry that you didn't get any responses on your first trip to DSXchange but welcome nonetheless. Most of the users of DSXchange are still at sites where Version 7 (and lower) is in use; there are not too many {large} sites implementing version 8 as of yet and most of the time the new inst...

What has happened is that you are reading the null value in the Date field from a sequential file; but you have also set the default value for the date field, so upon reading the default value is what you are getting.

Aakash - if you are still at the company you were before, isn't FTP disabled and only sftp allowed? If not, have you tried using the IP-Address instead of the hostname for your DataStage ftp attempt? It sounds like the /etc/hosts entry on your DS host machine doesn't match the hostname that the IP a...

Great, I'm glad you got that sorted out. If you could mark this thread as resolved other future searchers will get a quicker and better answer as well.

Yes. You could re-convert them to binary after transfer using EBCDIC(In.ColumnName) and then apply one of the SDK routines to convert the binary to a text number representation. Or transfer in binary mode and use the CFF stage.

and make sure you are in the project directory (ls should show hundreds if not thousands of entries, many with 4 digit numbers in their name).

do you have several projects? If so, that job might be related to another project.

It looks like these might be COMP-3 or binary values; or your column length is really only 7 and you have a { as the separator.

Odd, then please attach to your project directory from unix and see if there are any files in there with 3122 in their names. There should be several.

Job number 3122 cannot be found that way. From your admin command line try "LIST DS_JOBS WITH JOBNO EQ 3122" to get the job name that corresponds to that job number.

The output doesn't make sense. What were the 2 other commands you ran?

The output of the "ps -ef | grep osh" should give pids as well as text references to jobs. How did you get from there to job numbers?