Hi,
How can I convert date format from 'yyyy-mm-dd' to 'yyyymmdd' format ? Which is the date function to be used.Please let me know.
Thanks
**Note: Subject changed to be more descriptive - Content Editor **
Search found 5 matches
- Wed Jan 28, 2009 1:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How can I remove dashes in a date format?
- Replies: 7
- Views: 9981
- Tue Jan 27, 2009 3:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Is Wait for file activity Stage used only for static file?
- Replies: 3
- Views: 1790
Is Wait for file activity Stage used only for static file?
Hi,
Can I use Wait for file activity Stage for unknown files?or only used for known file?
Can I use Wait for file activity Stage for unknown files?or only used for known file?
- Fri Jan 23, 2009 5:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: To run datastage job through UNIX
- Replies: 3
- Views: 2752
To run datastage job through UNIX
Hi,
I am trying to run the datastage job in UNIX but I am not getting the command line prompt path where it should be executed.Please let me know.
Thanks
I am trying to run the datastage job in UNIX but I am not getting the command line prompt path where it should be executed.Please let me know.
Thanks
- Thu Jan 22, 2009 7:24 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Automation of daily file load into Oracle table.
- Replies: 4
- Views: 2222
Automation of daily file load into Oracle table.
Hi All, I am loading one dat file to oracle table daily.The dat file name is in the format 'filename_yyyymmdd'. I have parameterized the file name and file path.At run time I am passing the current file name and loading the data.Now I have to automate this process of daily file load to oracle table....
- Wed Jan 21, 2009 1:06 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Need to load sequential files to Oracle database daily.
- Replies: 2
- Views: 1611
Need to load sequential files to Oracle database daily.
Hi All, I have to load one dat file to oracle table on a daily basis.The filename is having the timestamp in it.I have to create a job sequence to automate the process of loading each file to oracle table on a daily basis.I have a column as 'AHM_file_name' in the target table which I am hardcoding w...