DSXchange

Hello To All: This is my first time working with the CFF stage and I did read through the documentation.I am trying to import the following COBOL Copybook into the CFF stage. I was reading some various posting from the group and it mentioned to start the level numbers begin at 5 or 10 and subsequent...

Hi all: I am performing a lookup based on the following SQL which is UserDefined from Table and columns instead of the "Generated SQL Query". DataBase is Oracle. SELECT CODE_LOOKUP_TYPE.CD_LKP_TYPE_ID, CODE_LOOKUP_TYPE.CD_LKP_TYPE_CD FROM ODSR1.CODE_LOOKUP_TYPE WHERE CODE_LOOKUP_TYPE.CD_L...

Hi all: I am performing a lookup based on the following SQL which is UserDefined from Table and columns instead of the "Generated SQL Query". DataBase is Oracle. SELECT CODE_LOOKUP_TYPE.CD_LKP_TYPE_ID, CODE_LOOKUP_TYPE.CD_LKP_TYPE_CD FROM ODSR1.CODE_LOOKUP_TYPE WHERE CODE_LOOKUP_TYPE.CD_LK...

can you please explain the use of $CommandOutput you use and how you implemented it? Thanks I got the solution. Instead of using $ReturnValue, I used $CommandOutput Thanks for your help. Gateleys: The SQL is fine...thinks are running fine now... --dtatem dtatem, since your problem has been addressed...

This is how I implemented the solution,based on the feedback I received from gateleys's responses: 1.In my DataStage job, I created a parameter defined as"pListValues" 2. In the SQL I make a reference to this parameter and test it in the job to make sure it works. 3. I created a Sequencer,...

Gateleys: The SQL is fine...thinks are running fine now... --dtatem gateleys In my UserVariables stage, you are right, I needed double quotes, but now when the job runs from the sequencer, it only processes one of the list values and not the rest. Can you check the log as to how the SQL is being int...

gateleys In my UserVariables stage, you are right, I needed double quotes, but now when the job runs from the sequencer, it only processes one of the list values and not the rest. I have no idea if this would work properly by the time it gets to your SQL, but try a string where your inside quotes ar...

I have attempted to use the UserVariablestage in aSequencer UserVariables----------->JobActivity In the UserVariables stage, in the first column I have "ListVals" . In the second column I have the values listed as "A","B","C"..but it appears that it doesn't li...

Thanks for replying..I like your idea of using the UserVariable Stage...a question about this, will I have to list all of values in the UserVariable stage?? So am I to understand if I use the UserVariableStage to store all the values, when the job runs, via the sequencer all values in that list will...

Good Day: I have a server DataStage job that reads from a DATABASE table base on the SQL below: SELECT C1,C2,C3 From Table where TYPE IN('A','B','C','D', etc...etc) The "IN" list can be rather long and to avoid typing in all the possible types in the SQL, is there a way of putting these va...

The JOBINTERIMSTATUS states the following: DSJ.JOBINTERIMSTATUS. Returns the status of a job after it has run all stages and controlled jobs, but before it has attempted to run an after-job subroutine. (Designed to be used by an after-job subroutine to get the status of the current job) My question ...

I was a bit quick on the submit button..but I found the variable.. thanks Can you tell me what is the variable for "INTERIM" status Hello To All: I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code JobStatus = DSGetJob...

Can you tell me what is the variable for "INTERIM" status Hello To All: I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) The content of JobStatus is 0[zero] when we...

Hello To All: I have an After job server routine that captures jobs statistics, row counts etc. In this routine I have the following code JobStatus = DSGetJobInfo(JobHandle, DSJ.JOBSTATUS) The content of JobStatus is 0[zero] when we insert it into an ODS logging table when the job completes OK. Inst...

Hello To All: I created a job where I am reading in 20 records.In these 20 records, I have created a stage variable, groupkey and assigned it a value of "1" with the data and this result gets moved to a copy stage. I am also using the DB2 Store procedure stage where I am passing these 20 r...