DSXchange

Also no need to check for the 0. iconv will return a NULL if it is not a valid date.

What if the date format you have in your TO_DATE?

It should be 'YYYY-MM-DD'

Here you go

oconv(iconv(vDate,'d4'),'d-ymd[4,2,2]')

vDate is your incoming date

i am using folder stage to read files from load directory . My files are fixed width length file .I am dfining column1 as file name and column 2nd as record( which suppose to contain records of file) . but in my job its taking only first rows of file.Please help me what i need to define so that it ...

Design the job as shown below: ------------------Surrogate table FlatFile -------> Lookup ---------->Transformer---------> DB2 ............................... ..................... Aggregator--------->Surrogate Table In the lookup stage ,lookup the table_name(target table name) field and retrieve t...

I'm using the function in one of the server job which is working fine. I just copied the same into a parallel job and hard coded the value but that doesnt work :cry: And thanks for your quick replies Anbu, I really appreciate it! I will mark this topic as resolved as all I wanted to know was, whethe...

Thanks Anbu. One more question before I go for one of your suggestions. BASIC_TRANSFOMER accepts the oconv function in a parallel job. But when I run the job it doesnt provide any proper output for this command. Is there comething we need to do to make it work or It will never work in a parallel job...

Hi All,

Is there a way/Function to change the format of the amount. E.g., Input value is 123456.78 and output should be $123,456.78

Whatever I'm asking is the equivalent of the below server function in parallel:

Server Fn: Oconv(Arg1,"$MD,2")

Chulett, From all that posts I came to know it was something related to do with the Oracle stage. I removed the oracle stage from my job and even then I'm getting this error. I split the job and wrote my src file to a hashed file and in the next job I read that Hashed file. Its working fine now. :lo...

"From previous run DataStage Job 4134 Phantom 31273 Abnormal termination of DataStage. Fault type is 11. Layer type is BASIC run machine. Fault occurred in BASIC program JOB.724382708.DT.1555211235.TRANS6 at address 94e." Above is the info I got after resetting the job. I have included it ...

Than DB and HF look-up is for the 2nd transformer.....

Hi All, My job abend with the error "Abnormal termination of stage EX_CreateSubXML..X_Src detected" The job design is like this: CFF -->> Transformer -->>Pivot -->> Transformer -->> XML O/P -->> HF ^ | | HF | | DB This error is related to the transformer after the CFF! First time when the ...

We had similar kinda problem when migrating from 7.5.2 to 8.1 But a little different issue. 7.5 gave more rows than 8.1 As per IBM's suggestion, we set the NLS of each column in the merge stage to be UTF-8 and it worked fine! :D But I really dont understand about it yet, because our NLS project defu...

I have used 3500+ columns in one of the job...

Doesnt your job use a sequence? Are you not running it thru scheduler?