DSXchange

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

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...

hii chulett

the maximum number is fixed ie- 30 .yes i am using a server job .kindly throw some more light on it

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...

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

yes almost

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

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

thanks chulett and others ...its done i am able to update it properly ....but now i am having problem in start loop activity .

what i need to do is run the sequence that number of times for which status is "NO".for this how can i give the end loop parameter ....

this variable i will get at runtime from my db by giving a count query ....that's in a server job ....how do i use this variable in sequence job as input parameter ....shall i use user variable stage ....how??

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

the file names are same ...the only difference is this unique id

yes the file and unique id have one to one mapping ...i am selecting one file which i am processing using other job in the sequence ....i wish to update status of the same file so i am using the unique id of that file

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' ...

Thanks for the reply everyone .i am using start loop activity and end loop activity for looping. now the table in db from which i am taking the file has a column as "status" which i have to update from "No" to "Yes" for each row that is processed.kindly help me with thi...