Search found 6 matches

by vijay.swarup
Mon Jun 18, 2007 9:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need to access data in different files,merge into temp table
Replies: 3
Views: 1828

Hi Ray
Thanks for the quick reponse.
I have no premium membership and i am not sure i will be in this tool or some other tool and after some time i will pay the amount.
Please provide the solution for this.

Thanks in Advance
Vijay
by vijay.swarup
Mon Jun 18, 2007 8:49 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: need to access data in different files,merge into temp table
Replies: 3
Views: 1828

need to access data in different files,merge into temp table

Hi All I have a requirement like get column data from different files(files are in differnt locations and paths) and merge them and load in a temporary table so that BO reports are build taking that temporary table as source query. we know only the column names and based on these columns we have to ...
by vijay.swarup
Wed Jun 06, 2007 9:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: writing batch control for ftp files in unix
Replies: 3
Views: 1780

Hi Ray
Thanks for the response.But the client is asking me to do batch control for this purpose.Please do guide me for the same.

Thanks
Vijay
by vijay.swarup
Sat Oct 28, 2006 4:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: VARCHAR TO DATE CONVERSION
Replies: 3
Views: 1930

VARCHAR TO DATE CONVERSION

Hi I am using Datastage 5.2 server edition.My source is sequential file of varchar type and i am transforming to date type in the target which is oraoci stage.I tried using oconv and iconv ,substrings functions but not able to get the result.I searched the forum but could not find exact post. Ex: so...
by vijay.swarup
Tue Nov 22, 2005 11:21 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datetime Issue based on Different Platforms
Replies: 4
Views: 2288

hi, here i can suggest a small solution to your issue... you try to use " DateTimeStampToInfCLI(<input timestamp>) " this function converts timestamp to date. this function is available in DSRoutines/SDK. there are many similar functions of different drivers compatible you can try for apt ...