DSXchange

Hey Kenneth, have you been peeking at my code? (ref: blah blah blah)[:D]

Tony

I just looked at the 'DateTimeStampToOraOCI' routine under Routines/SDK/Date in the repository. It looks like it takes a date in the format 'YYYY-MM-DD HH:MM:SS'. This routine uses ' 00:00:00' for the time part...

Good Luck,
Tony

Is this Unix or Windows? Are you in a different group than the other people that can run the process? What happens when you try to open this file manually?

Tony

Angel, I'm no expert at this, so I may be way off base here. :) I know that you have to have the environment variables set up correctly for DataStage to see the Sybase client drivers. The environment for DataStage can be configured in the 'dsenv' file in the ../DataStage/DSEngine directory. Good luc...

Emma,

There is an FTP stage that comes with DataStage. I don't know if it's what you need or not.

Tony

Guillermo, Typically you can get each field from a delimited string by using the Field function. An example of getting the first field might be: Field1 = Field(InputString, ",", 1) To return the fifth field in the string do: Field5 = Field(InputString, ",", 5) I'm not sure I corr...

Chandra,

The proper way to stop a job is to press the Stop button (the little square) or Select Stop from the Job menu within DataStage Director.

Tony

chandra, You MUST use the DataStage Director tool to stop a job. If you kill the processes, the internal status in the DataStage engine is not updated. You can reset the job status from DataStage director, if you have "Enable Job Administration in Director" checked in the project propertie...

Ray, I get an NLS mapping error on the last sequential file stage, not on a transformer. The message is something like: TonyTest..Sequential_File_2.DSLink9: nls_map_buffer_out() - NLS mapping error, row 18862 (approx), row = The mapping on both the Sequential file input stage and the Sequential file...

Steve, As Craig said, you can do this with the hash file in a directory other than account, but you have to create a VOC entry for it. Ray explained how to do this one time, but I don't have it handy. And I'm still learning Universe (still learning DataStage for that matter ), so I don't have this o...

ND, If you store the hash file in the account, rather than in a directory, you can access the hash file using a Universe stage and putting the hash file name as the table name. You can specify just the one field as a key field in the meta data in the Universe stage and do the lookup that way. Good L...

Ray, I constructed a simple job that read the source file, ran it through a transformer and wrote it to a flat file. No problems. SourceFile-->Transform-->OutputFile I modified my test job to read the source file, write it to a hash file, then read the hash file, through a transformer and write it t...

Nitin,

I don't know of an easy way to do this. The best way might be to copy and modify the KeyMgtGetNextValue routine to handle your particular algorithm.

Good Luck!

Tony

Cal, I'm not sure from reading your responses that I completely understand your problem. Assuming that I do, you can return the database sequence to DataStage by using user-defined SQL as Ray suggested. Something like: Create an Oracle sequence: Create sequence ds_seq; Get the value into DataStage (...

Hi Ray, thanks for the reply. The mapping is as follows: 1) column - Allow per-columnn mapping is not checked and I have not explicitly set any mapping on these columns. 2) stage - The NLS tab on the stage says "Project Default (ISO8859-1)" 3) job - The NLS tab on the job properties says &...