DSXchange

Hi all,
if i use isnull function in ETL on a numeric field?it will hit the error?Urgent one. Please help!!!

Hi all, I am planned to delete a sequential file after run a job.But my shell script have problem.The problem is like this: I pass the sequential file name as parameter to shell script. the shell script will read a text file which the text file name is the sequential file name and the other files' p...

the source stage facing this problem. i think is because of user id and pwd not correct..any ideas?

Hi all,
any idea with this error :" User Id is a required stage property".

Thanks 1st.

Hi all
i hit the error :
"DataStage Job 3094 Phantom 24845
Unable to open "/tmp/capture57558aa" file.
Attempting to Cleanup after ABORT raised in stage TalismanMinH..TABLENME_MinH
DataStage Phantom Aborting with @ABORT.CODE = 3"

Any idea?

ok .roger that.

Thanks u all. I already found out the error. It is because of the connection setting issue.

here is my previous question 's SQL statement : INSERT INTO DMCHM_IB_RGB_DTL (LRECSEQNBR,LIBSEQNBR,NBENTYPE,STRDESGNCD,STRAGENTCD,DAMOUNT,DINTRATE,DTPERIODPROCESSTO,DTPERIODPROCESSFROM,DINTACCR,DTOTPREVBENAMOUNT,DCURRENTBALPAR,DCURRENTBALNPAR,DCURRENTBALLINK,DINTCURRENTPAR,DINTCURRENTNPAR,DINTCURREN...

Hi all,
now I had hit another similar problem.But this time is more funny,it say "SEQNO" : invalid identifier. I had check the source and target table , the SQL statement, transformer. But still come out this error. Can anyone help?Thanks.

Now I want to run a job to transform sybase data to oracle data . I hit the error :" dmChmIBRGBDtl..Trans1: ORA-00904: "DINTACCRUEDNPAR": invalid identifier" both of the tables contains same data set ,no any column is missed including the DINTACCRUEDNPAR , what else will cuase th...

hi, I run a job and it is aborted .It gives me the error message :" invalid identifier". Normally, it is because of either source or target table don't got such field. But I had checked and the field is existed in both source and target table ,and their data type,length also the same. What...

Hi chulett,
u r right. job parameter can be used in after-job routine. how about the stage variable? can it be put into after-job routine as well?

Hi chulett,
how do i put my job parameter inside the input value of "after-job routine"? let say my job parameter is : DATA

so ,is it put like this in input value box:

:DATA:

Plz advice.

Hi ArndW,
what I know is, the job parameter only functioned during run-time . So, after the job runned, job parameter will not abled to "used" in after-job routine. am i right?

Thanks guy/gal . u all r helpful.