DSXchange

This would not work with a before-job subroutine. The correct way to implement this is to use a job sequence where you execute your external command(s) and then pass the results to the job as parameters; those can then be used in your transform stage. hi ArndW, i create a job sequence with the exec...

This would not work with a before-job subroutine. The correct way to implement this is to use a job sequence where you execute your external command(s) and then pass the results to the job as parameters; those can then be used in your transform stage. hi ArndW, i create a job sequence with the exec...

Hi All, I have a scenario like: i have a source sequential file, i need to get the total number of rows for that file in to the transformer stage and need to be load the count in to the database. i used the before-jobsubroutine by execut shell option and input value as awk 'END{ print NR}' <filename...

hi :) Is there any DS Command to Find the Particular Folder name and export it from the entire project. I am Working in DS commands in different Versions of Datastage 7X and 8X. In 7X dssearch command is working but in 8.0.1 it is not working. Through dssearch command we can find the fodler name und...

Hi :) I am using the IBM AIX SERVER , it has Datastage Ibm Websphere 8.0.1 and oracle 9i. Now my hard disk has been crashed in Aix Server. Before that happens i have taken the entire project Back as .dsx using DSCMDEXPORT command through unix shell scripting which was scheduled. Now the .dsx file wh...

richdhan wrote:Hi,

The GUI export is the one that is available through Datastage Designer.

--Rich

what is the syntax for that GUI export? please share it!!!

thanks in advance
kamal

chulett wrote:You can't - one job or the entire project are your two choices. You'd have to use the GUI to export a folder / category. ...

What is that GUI export .. in the above you mentioned?

hi, i want to take backup of particular folder in datastage IBM websphere PX through command line dsexport. but it seems we can take for a particular jobs alone as a backup. but i dont know how to take backup of all the jobs in a particular folder. E.g: the below shows for particular job to take exp...

how to write that loop.. pls say that ..if possible pls give the command for that

thanks
kamal

hi All, i want to view the log information for all the jobs in a single project at a time. i knew by using DSJOB command i can get it fro single job by giving project name and job name for the logsum option. but i want the syntax for all the jobs loginformation in a particular project at a time. for...

hi, i want to list the name of job which takes more time for execution through unix shell scripting. first, i want to know how to read the RT_LOG FILE which will be stored as hash . whether this file can be readable or not through unix scripting ? and how to find the particular log file for a job na...

hai, we know the way how to subtract between two dates in datastage,but how to subtract between two timestamps.. example: a) 01-jan-2001 01:30:45:000 b) 04-jan-2001 02:30:45:001 i need to perform a-b & output must be in number of hours. how this could be done in datastage. it could be great and ...

hi, please help in solving this problem.... 1.The input file contains the following records, column1, column2 , column3 , column4 1 , _ , _ , _ _ , 2 , _ , _ _ , _, 3 , _ _ , _ , _ , 4 *here underscore( _ ) indicates null value.. 2.The output file must contain all the values of input file in a singl...

Hi, please help me in solving this case study... This is the scenario to be consider to implement scd 2 in my case study, i have the following columns with the data in the input sequential file... -->input_sequential file ---------------------------- contrid contlineid product_name start_date end_d...