DSXchange

Hi All,

In the job properties windows from datastage designer 8.1 there is a check box "enabled for information services". Is this related to webservices pack.

I did not find this check box in datastage 7.5.2

Thanks
Mark

i understand that etl will delete this file and it does not contain any data.

what is named pipe.

Thanks
Mark

Inside the generated control file ora.xxx.xxx.o.ctl file i found a data infile as ora.xxx.xxx.fifo.0 "FIX xxxx"

where do I find this fifo file.

Thanks
Mark

I have a etl job which loads data into a oracle DB using sql loader (Load option within ORAcle EE stage). I am trying to find the sql loader data file generated by etl. can anyone suggest me where do I find this data file.

Thanks
Mark

Thank You.

I will send an email to mbership.director@dsxchange.com to find out the status of my membership

Thanks
Mark

I am only see partial response. Rest of it is hidden. I am a premium member but still not able to read your complete response.

Thanks
Mark

Thank you. How do I create a dynamic array in ETL.

Thanks
Mark

Hi All, I am trying to code this in a stage variable in data stage version 8.1 if link.ID not in (40,50,100) then "do this" else if link.ID = link.ID then "do that" else "remain where you are" Can someone please let me know how do I accomplish this. I could not find any...

The datastage jobs (which ran successfully before) are aborting with this error;

Error writing to jpfile

can anyone please suggest me what this error mean and where do I look for resolution.

No changes were made in these jobs and they all run on multiple instances.

Thanks
Mark

Hi All,

1 of my data stage job aborted with this error.

Error setting up internal communications (fifo RT_SCTEMP/XXX.fifo
LOCKED STATUS () -1); file is locked

Can anyone please suggest me what caused this error and what do I have to do to fix this.

Thanks
Mark

Thanks. I want first occurance in the delimited string.

Thanks
Mark

HI All,

I have a record with column, say B.

The data in this column can vary from record to record.

Column B data:

1,2,3
10,2,3,4,5,6,7,8
7,4,5,6
23,56,87,12,333,444,555,66,777

Desired output from column B is:

1
10
7
23

can anyone please suggest me.

Thanks
Mark

so far just mine :(

Has anyone faced any issues with sequential file stage in datastage v8.1 such as
data stage client locking itself while working on a etl job with sequential file stage.
just working if there is any patch for sequential file stage for datastage 8.1

Thanks
Mark

I have seq stage ---> copy ---> oracle enterprise endition stage. inside Oracle stage, i have upsert mode. insert statement and dummy update statement. whenever insert statement runs it is not necessary there will be inserts in the table. such as insert executed, 0 rows inserted. insert into table_n...