DSXchange

Each column within a table definition can have a data element assigned to it. Make sure you are using Timestamp and not Time as the data element type (see the DataStage Director Help menu, look for "Data Elements" and "Built-In Data Elements").

Brian Fennell

I have a requirement where the source file has data like (((sample data))) How to get file1 values or that particular record. I want to know if it can be done with looping. I notice in your sample data all fields appear all the time. It looks like "DONE<NEWLINE>" is your record separator ...

I am not sure of the issue: do you want to get the file name before you get the file, or after? Do you have access to the remote server via some way other than sftp? If you can get the file with a wildcard, but cannot list the results, you could try putting it in a local directory you know is empty ...

Thanks! I went back in just now and noticed that the DataStage Director default view had a "(filtered)" message at the bottom of the DataStage Director window. I right-clicked on the root project icon and changed the filter from "Job Status: Terminated Normally" to "Job Stat...

You may find this thread interesting:

viewtopic.php?p=147391

I am new to this forum I am looking at a DataStage job (JOB-A) created by someone no-longer with the company. I see in the log (in DataStage Director) that it calls a second job (JOB-B). The named job (JOB-B) does not appear in the left-hand-side tree pane in DataStage Director - and I want to see i...