Search found 27 matches
- Fri Jul 18, 2014 4:43 am
- Forum: General
- Topic: Capturing Time from job logs into excel sheet
- Replies: 1
- Views: 1201
Capturing Time from job logs into excel sheet
I need to capture data such as time of completion of job,time at which a file came etc . from job log into an excel sheet .how can this be done in the most efficient way
- Wed Jan 22, 2014 7:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Lookup space separated values individually
- Replies: 1
- Views: 2377
Lookup space separated values individually
hiii i have data coming in a table separated by space . i wish to lookup each value from the lookup table individually and enter them in db separately Input: abc ghi jkl def Lookup table is like : abc 1 def 3 ghi 4 jkl 2 Output should be like: 1 4 2 3 i am not getting how to do the separate the data...
- Tue Oct 15, 2013 1:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: parsing comma separated values coming from xml
- Replies: 4
- Views: 2709
- Mon Oct 14, 2013 12:52 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: parsing comma separated values coming from xml
- Replies: 4
- Views: 2709
parsing comma separated values coming from xml
hii all My input is like - Abc,Bcd,Cde,Fgh i have to parse this and perform lookups separately for each of these (number of comma separated values is not fixed) Also i need to insert lookup id's and some other data individually into my db so in db entries will be like 11(Lookup id of Abc) 20 30 40 8...
- Fri Aug 02, 2013 1:09 am
- Forum: General
- Topic: Impact of db2 crash and creation of new instance
- Replies: 1
- Views: 1198
Impact of db2 crash and creation of new instance
my datastage is installed on AIX box .due to some reasons my db crashed.i have backup of jobs made .
the db2 will be reinstalled with a new instance .what is the impact andwhat changes need to be done in configuration to make it working like before
the db2 will be reinstalled with a new instance .what is the impact andwhat changes need to be done in configuration to make it working like before
- Thu Jul 11, 2013 1:38 am
- Forum: General
- Topic: import data from excels
- Replies: 5
- Views: 4081
Re: import data from excels
yes almost
- Thu Jul 11, 2013 12:43 am
- Forum: General
- Topic: import data from excels
- Replies: 5
- Views: 4081
import data from excels
i need to process excels
which i have converted to csv and trying to import using sequential file
The data in excel is in form of 2-d tables .how can it be processed
It is also needed to pick some specific fields from the csv , can this be done somehow like we pick fields using tags in xml
which i have converted to csv and trying to import using sequential file
The data in excel is in form of 2-d tables .how can it be processed
It is also needed to pick some specific fields from the csv , can this be done somehow like we pick fields using tags in xml
- Tue Apr 09, 2013 4:50 am
- Forum: General
- Topic: parse year from calander
- Replies: 1
- Views: 1465
parse year from calander
hello all
i a getting data from some form in calendar format ie dd/mm/yyyy .i have to separate year (yyyy) from here and put it in the db .how can i do that
i a getting data from some form in calendar format ie dd/mm/yyyy .i have to separate year (yyyy) from here and put it in the db .how can i do that
- Mon Mar 18, 2013 2:58 am
- Forum: General
- Topic: looping jobs
- Replies: 13
- Views: 4963
- Mon Mar 18, 2013 2:56 am
- Forum: General
- Topic: give a variable as end parameter in loop start activity
- Replies: 6
- Views: 2436
- Fri Mar 15, 2013 4:36 am
- Forum: General
- Topic: give a variable as end parameter in loop start activity
- Replies: 6
- Views: 2436
give a variable as end parameter in loop start activity
i am using a loop activity .the number of times the loop runs is n which is a variable .how to use this in end parameter of start loop activity
- Fri Mar 15, 2013 4:27 am
- Forum: General
- Topic: looping jobs
- Replies: 13
- Views: 4963
- Fri Mar 15, 2013 1:04 am
- Forum: General
- Topic: looping jobs
- Replies: 13
- Views: 4963
- Fri Mar 15, 2013 12:30 am
- Forum: General
- Topic: looping jobs
- Replies: 13
- Views: 4963
Each row in my table has a unique id which i wish to use as a parameter to update the status in the table. can i use this unique id as input in db2 stage as the key to write an update command .how?? if not pls tell me how to use this parameter and update my status update table_name set status='yes' ...
- Wed Mar 13, 2013 6:53 am
- Forum: General
- Topic: looping jobs
- Replies: 13
- Views: 4963