DSXchange

Previously, I was trimming a space.

vFDATE = ScreenOutput
vFROM_DATE = TRIM(vFDATE," ","A")

Appreciate if you could provide a an example on how to use trim @FM.

Thanks.

agatha

Hi all, I've a shell script to get date from table, then print it to datastage. In shell script the date returned is fine but when it went to datastage, it returned date follow by a new line. Thus making the child job inherit the parameter(date) to a null value. Suspect it takes value at the new lin...

No...I mean the output file will then going through a transformer for my current dsjob. Will it be the root cause that, the transformation of file changing the default file format?

Btw, I cant see rest of the line....

by default it will generate ASCII file. But then the output file will then transform, is there any possibility that the output file change to binary file after going through transformer?
Weird char as in a square box appeared. When it inserts into table, it appears as space.

Dear All Expert, I would want to seek for your advise that, i've a dsjob that will query a table in db then output the result in a flat file. May i know how do i change the flat file type to either ascii or binary? As the output result containing some weird character when i opened the flat file. Fyi...

arh, it's abit too late to come across your post. I've kill it in unix but the job status become finish? By seeing the log, the job was modified by me that added in a sleep function causing the job running in a loop that keep greping a process that is still running. Anyway, thanks for your replied. ...

Thanks chulett.

I grepped the process using this command "ps -ef | grep phantom" but I found that the process is still running.

Should i continue with clear the status flag?
What probably causing this to happen that the job is not reached the finish point?

Thanks chulett.

I grepped the process using this command "ps -ef | grep phantom" but I found that the process is still running.

Should i continue with clear the status flag?
What probably causing this to happen that the job is not reached the finish point?

I have a dsjob that has been running for several days, it suppose to finish in 10 minutes time. It connected to oracle DB that i wish to kill the session but it appears weird that the session wasn't there. I been hitting stop button in datastage few times. May i know if there is any solution? Thanks...

Hi Ray,

it is resolved by rename the hashed file
The hashed file now created.

Thankful to you despite I cant read the whole content of your reply.

I have a hashed file corrupted. And tried several method to resolve this. Method as 1. delete the job and reimport, error was operating system file already exists with the name "D_PREPAID_SUBSCRIBER_HASH". 2. delete.file and uvfixfile. Error was no privileges. Only superusers is allowed to...

It is working now. Instead of grepping the bad file, I redirect the return code of sqlloading to a file and grep the result there.

Thank you, chulett.

Hi all. May i know how to have the rsh command's return code correctly? I have my script as `rsh 10.1.65.196 -l ciopr01 ksh "/recovery/dmprod/prepaid_loading/scripts/DM_Sqlldr_enh.ksh ${TARGET_TABLE_NAME} ${JOB_NAME} ${DATA_SOURCE_NAME} ${USER_ID} ${PASSWORD}"; echo$?` Even if my DM_Sqlldr...

Thanks very much.
It works now with the ORACLE_HOME path defined.

Thanks very much.
It works now with the ORACLE_HOME path defined.