DSXchange

I'm getting this error "Unable to open project 'dwh_uat' - 81016." While running sequencer CopyOfSeq_ACRW. Looks like Licsence issue.

any help?

Define variable as job parameter, In the Before/After exec You can use that variable as #variable-name#

Excellent. that would work perfectly for me. Sorry if this is a very simple task, but how do I go about making this a multiple instance job?

Edit: Got it, Thanks again!!

Hi, I have multiple sequences that will run at the same time, each running a job to load a different table. After that completes, each sequencer calls one common job, that updates a processing status table. My question is, what happens if sequnce a and sequence b are running, and sequence b tries to...

Have a JOB parameter for the period and use it as part of the table name in the DATABASE stage. something like TEMPTABLE_#Param_Period# Every time you run the job, you will create a new table. But you need to be mindful about the fact that when the period doesn't change, table need to be dropped or...

Hi,
Newbie Questions
I am reading sequential files using file pattern & trying to load temp tables for each changing time period(YYMM). I need to pass parameter to Oracle stage to create tables with changing YYMM?

Thanks in Advance.
SP.

ray.wurlod wrote:What particular DataStage functions did you attempt to use?

A follow up to the initial question, How to count the bytes in a variable length record in a parallel job in v7.5, when the input sequenial file has record level and record type set as varying?

When attempting to count number of bytes in a derivation, from a field length of 3764 binary to a output column of 68 + Len(INPUT.column) (interger) we are getting the following error. We have attempted using DataStage functions and string in transformer itself. Error in output column derivation exp...

I have a job that runs on multiple insancing using a shell scripting...it is a job that extracts data from an Oracle database and puts it into a dataset...The shell script triggers this job mutilple times in the background all at a time... when I run this script(which in turn runs the job) it runs f...

Can the Oracle Merge statement consume orchestrate data columns in the USING clause to make it parallel. Right now I am loading an staging table and using a select in USING claues to perform the MERGE. My goal is to try and eliminate the staging table and feed the data directly to the ORACLE Stage c...

Hi, I am running a dsjob (Multiple Instances) using a shell script from the execute command stage. If all the instances of the job run then i return a code 0 else 1. I trigger two different jobs based on the return code.I tried using stage_value.$CommandOutput and stage_value.cmd.$ReturnValue but bo...

Hi I have a job that extracts data from a table in oracle database and puts it into a dataset.this job takes the a parmeter 'period' and runs the job.how can I run 'n' number of these jobs (all these jobs should be running at time not one at a time) each taking a different parametre value. in other ...

Received the following error when importing a job:
Error calling subroutine: *DataStage*DSR_SELECT (Action=3); check DataStage is set up correctly in project fbr_rel
"subroutine failed to complete successfully (30107)" site:ibm.com

Thank you! The year_cutoffyy will work! Thanks for your quick reply.

I used StringToTimestamp function and was using 'yyyy' for the year for masking. However, for 2-digit '07' as the year, it was populating it with 19 --> so the result was 1907, instead of 2007. What is the proper mask to put the correct century? The on-line documents do not have examples. Any input ...