DSXchange

Hi, Recently we had upgrade our V8.0.1 to fixpack 3. After this fixpack, i had encountered problem using stored procedure stage(STP). My job design is just only STP stage with input parameters. Previously, i had no problem for this job when i am running on V8.0.1 fixpack 1. After i turn on the debug...

Does Oracle stage in Datastage V8.0.1 support oracle 11g?

Hi All,

How can i convert mmm-yyyy to yyyymm without using basic transformer? With parallel transformer, there is no oconv and iconv functions.

Thanks in Advance.

Hi, When i reset the job, the job will still hit the same errors. Normally, i will have three solutions to overcome it : 1) Clean up the resources 2) Create a duplicate of the current job 3) Restart the services. I am using basic transformer due to i am using server routines to do transformation of ...

Hi, When i reset the job, the job will still hit the same errors. Normally, i will have three solutions to overcome it : 1) Clean up the resources 2) Create a duplicate of the current job 3) Restart the services. I am using basic transformer due to i am using server routines to do transformation of ...

Hi All, Is it recommended to use basic transformer in the parallel environment. My jobs are hitting the following errors: Abnormal termination of stage JB_LU_HIST(BASIC_Transformer).#3.BASIC_Transformer detected. I had tried to switch them to be running on sequential mode, sometimes it will works we...

thanx a lot..

thanx thanx, it works prefect well. But i got another question. I had tested my jobs both in windows and unix. Unix works fine. But when i am trying to compile the jobs in windows. It doesn't work. Does it means that window will have another method to solve this problem? The error that i get when i ...

I had this inside the sequence. But inside execute command, i can't indicate this.

my flow is

execute command --> start loop --> execute command --> end loop

is there anyway tat i can amend inside the execute command so that i can make the job function well.

how can i remove the line terminator? I am passing the values inside the sequential file to do the loop.

Ok. Thanks.

Bcos i am grapping the data from database. Although is known that the format will not change, there are times that records are rejected when it is load inside database. If FF records does not load inside database. My whole job will go haywire bcos i am using field to determine. Are there any better ...

File Pattern

For Example : Key Fact_Type FACT_VALUE 1 FF 10 1 FP 20 Output Results Key FF FP 1 10 20 Currently, i am using stage variable to concatenate it. After Concatenate, the result will be FF|10|FP|20. After getting this result, i will use field to get the value. If FF does not exists, my whole job will be...

The bug is at the sequential file. For Example : abc.txt|abc2.txt|abc3.txt Newline (but when i view the data in datastage, it will only be view as one row) When creating a new sequential file in datastage, it will always give me a newline at the end of the whole file, even though i remove all the de...