DSXchange

Hi, Data Stage 7.5.2,DB2 UDB,AIX DB2API stage (Table name)>>>Data set stage Here "Table name" is passed as parameter to read the data and writing to a dataset. Option 1:I am using UNIX script to trigger the job from command line : /script>sh run_job.sh "Table name" ##############...

@ray, Thanks 1."multi-instance sequence"..(I am not familiar with this kind of approach ) 2.Yes..I do have some Batch jobs runs using "job control routine"program Ex:Master Batch :processA that triggers subsequent jobs by taking Job Parameters :"parameter file "and &quo...

Hi,
Is this is what your are looking for ???Can you please quote your job design in "code" with input and out put links

If job design is clear you can expect more responses

Thank you

Hello Everyone; Environment :Data Stage 7.5.2, AIX server , DB2 UDB Requirement:To generate data sets corresponding to the different table names using parallel process.. Ex:Employee table has different load tables like Employee_01,Employee_02 (loaded weekly,monthly etc..)Have same "meta data&qu...

@ray There is a limitation on server lacks "large file support" Environment:Data Stage 7.5.2 Parallel Edition compare two datasets(Today's records and previous days records) >>>CDC>>>target delta (sequential file) We are looking to fix this issue by modifying the job job such a way that it...

1.What are you trying to do exactly ??Here you could be more specific by specifying the job flow..then you can get more responses.. Ex:Dataset stage >>>xfm>>peek/sequential file 2.Did you Souce file pathname correctly?? Output link >properties tab>>source/file 3.Did you specify the meta data correct...

Hi Vijay, "build the file "Indicates that we have to "write a SQL query in a file format mostly (.sql format )>>Please double check here for Format "actual parameter value "implies that for eff_dt include same value not as #eff_dt#.>>The reason behind Parameters usage is to ...

It depends on how you are invoking the script. Do you have an automated way to run the script with input parameters? Hi, Currently I am using .sh script to unload from DB2 Table: #!bin/ksh if [ $# -ne 1 ]; then echo " " >> $JOBLOG_DFLT echo "** Argument missing ** i.e., Table name not...

@Franklin,

I am not using any scheduling tool and thought of implementing using dsjob commands:


dsjob -run -param "Query=select statement ..."


Any idea to implement this kind of command

Thank you

It looks like the requirement is "telling" you how to design the job. There are other and to my mind better ways to approach this. Just as a first thought: A table with two columns, an identifier and a char column with the text of the query in it. Your parameter would be the identifier, a...

Hi All, I Have the same requirement to pass the SQL query as parameter to the job for reading column names for the given table.. I have multiple table names with similar column names..so I want to parameterize such away that it should read the column names from the Query and generate output file..Se...

Hi, I am new to the mainframe DB2 UDB databases with UNIX Environment:AIX 5.3 ,putty,command line processor DB2 Putty: I login to DB server(devit) using user name and password Showed me Database information..(devit) db2=>? help 1. Hoe to execute commands to view all tables/tablespaces/scmeas in (dev...

1.How to parameter jobs without code modifications for file creation everytime?? @chulett I Have the following scenario needs to be implemented: Environment:DStage7.5.2(Parallel edition),AIX 5.3,DB2V8. step1:Unload tables :-We have DB2 Tables:1)base table ex:customer 2)monthly tables (25 ):customer...

More collaberatively : We have recently migrated the DataStage code(Scripts DB2UNLOAD.sh ,csvs,ini's etc..)from different dev (A) .Now want to check and see if is feasible to run in current Dev (B) with the changes? Update the jobs (things to consider )??? details:The Environment B..is Parallel exte...

Hi, Current Env:parallel edition (7.5) I am doing analysis on "recently moved code "from server edition.(7.5) 1.How to parameter jobs without code modifications for file creation everytime?? 2.what things to understand from environment prospective (sources ,db2 connections/configurations,e...