Hi,
I have a file in Unix which is in this format.
I want to use this as a source in my Datastage job.
The problem is the file is located in Unix Env, where the path is differnet from our working directory path.
there are 5 differnt files, with this structure.
how can i use these in datastage and whcih stage i have to use.
In the design i have to send a mail if Rejects are > 0 only.
TableName|Src|FileId|Processed|Inserts|Updates|Rejects|Datafiles Processed|TimeStamp |
AMZN_CUST_W | 72| 1| 88605| 88605| 0| 0|10/04/07-10/04/07 | Thu Oct 4 13:33:03 2007
AMZN_FRD_DATA_W | 72| 2| 434361| 431948| 2410| 3|10/04/07-10/04/07 | Thu Oct 4 14:27:13 2007
AMZN_CUST_ORD_W | 72| 4| 220595| 219668| 927| 0|10/04/07-10/04/07 | Thu Oct 4 14:30:39 2007
TableName |Src|FileId|Processed|Inserts|Updates|Rejects|Datafiles Processed|TimeStamp |
REMV_STAT_W | 72| 10| 20| 0| 20| 0|10/04/07-10/04/07 | Thu Oct 4 14:30:49 2007
AMZN_CUST_SETL_W | 72| 11| 40682| 40682| 0| 0|10/04/07-10/04/07 | Thu Oct 4 14:31:24 2007
5 of 9 tables loaded
Following tables NOT loaded:
AMZN_FRD_ORD_CAN_W - File was not received or was received as an empty file.
AMZN_ORD_REINST_W - File was not received or was received as an empty file.
AMZN_ORD_SRC_W - File was not received or was received as an empty file.
AMZN_REF_TAG_SRC_W - File was not received or was received as an empty file.
Please help me.
Thanks in advance.
File from Unix....
Moderators: chulett, rschirm, roy
Re: File from Unix....
pavans wrote:I want to use this as a source in my Datastage job. The problem is the file is located in Unix Env, where the path is differnet from our working directory path.
![Confused :?](./images/smilies/icon_confused.gif)
See above. Either a wildcard pattern to read them all at once or a looping job structure so that you can process (and notify) one at a time. If you are on a 7.5.x release, then you have the Loop and UserVariables stages in Sequence jobs which make that pretty straight-forward.pavans also wrote:there are 5 differnt files, with this structure. how can i use these in datastage and whcih stage i have to use.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers