DSXchange

Try doing a simple single-key lookup to your DB2 stage. Activate the automatically generated SQL, and then click on user-defined so that ityou can edit the existing SQL. From that you will see the format and syntax and can add your own between condition easily. Thanks for the advice. I stuck to the...

Hi there, I know there are various threads about Range lookup done in PX jobs. However, I can't seem to get an sql right were I to use the lookup directly from Db2 stage. E.g. Primary flow ======== Name, transaction_date DB2 reference table ============= transaction_id, min_date, max_date How do I s...

Hi guys, I am encountering the below warning each time I load data into the db2 server: FNC_STG_DATA1: The environment variable DB2INSTANCE is currently set to `db2inst1' and is being changed to `db2inst2' as specified in the server option; if this instance is a different version of DB2, the program...

Change your mindset. Parallel job philosophy is "one stage, one task". The Lookup stage performs lookups. It has no other function. If you want to pre-set the lookup key, do so in an upstream Colu ... Hi Ray, Thanks for the feedback. The reason asking this is because I am required to tran...

Hi Guys! Just a lil' curious. Currently, my project involves utilizing server jobs. The design is like this. I have a sequential file (main flow), columns: 1) Customer ID 2) Name and a lookup hash file (Which serves as independent lookup) columns: 1) Area ID 2) Address Utilizing a transformer to do ...

Hi all, I have a small question for research purposes. I have a job that loads data from an sql server stage to Oracle stage. My question involves what is the commit interval set for the oracle stage by default? Let's say my sql server source involves 10 million records, I don't think it will only c...

Hi I am not sure what this error means. buffer(7),0: sendWriteSignal() failed on node PSADC1UXP031 ds = 36 conspart = 0 Broken pipe I am not certain which part this error come from as I have no access to the job design for this job. However, could you indicate roughly what's the cause? Could it be b...

Hi Ray and Arnd, I cannot view the extend of your replies. =P Being a non-paying member. I will work out with my co. and see if I can open up that membership later. At the mean time, thanks, you have given me an idea about the force abort statement. This code was not developed by me and I have no ex...

rasi wrote:Chang

if Increment <> 0 then

Where do you assign Increment variable. I can't see this variable assigned.

Thanks

Hi Rasi,

Increment is a parameter taken from outside the routine stage. I have a link to that routine stage with parameters TableName and Incremment.

Hi all, Here it is: Call DSExecute("UNIX", "echo $ENVSTR", env, rval) env = left(env, 3) Openseq "/" : env : "/job/KOR/" : TableName : "_PeriodNo.txt" To INPUT Then Call DSLogInfo("File read.","getTablePeriodNo") End Else Abort Re...

Hi all, This error is randomly happening. Basically my job design is like this. I have a job that concurrently runs 4 routine stages (Which all of them is acutally pointing to the same routine written just different table name parameter). And I am having the below error: "DataStage Job 1036 Pha...

Hi all,

I apologize, i am in haste for answers so I posted it first before started searching.

Sorry this won't happen again.

Thanks.

Nick_6789--

Hi all, I have this error whenever I tried logging into DS designer/director: "Error calling subroutine: "DataStage "DSR_SELECT (Action=4); check DataStage is set up correctly in project MIFACTBASE (Subroutine failed to complete successfully (30107))" I have been indicated to res...

Hi all,

I am just wondering does the subjected scnerio actually eats up db server resources? I am using Oracle 9i

kcshankar wrote:Hi Nick,
After Searching the forum for Parallel job reports failure (code 1),I got this linkviewtopic.php?t=92186&highlight=reports+failure.


regards
kcs

Thanks kcs. =)