DSXchange

Hi All Can anyone explain why Hash File Accepts NULL as valid value in a Key field when populating it and while reading data from Hash file it passes "?" for the particular field????????? I have Two Jobs Designed as below . 1)Reading from a Sequential file stage (with no keys) and populati...

Hello All

Please Correct me if i am wrong,

we have NLS map MS1251 default in our project .
We have jobs aborting with the error mentioned in this chain .

So , if i change the NLS setting to UTF8 in the jobs that will solve the problem?


Any suggestions appreciated
Thanks
Paddu

No problem

NulltoEmpty should be your solution ,

I have a situation where i compare 10 columns from Hash file (lookup) to the source .i concatenate 10 columns with the synatx below for comparison .

((NulltoEmpty(Col1)):(NulltoEmpty(Col2)): ..so on)

My jobs reads data from a flat file and does tranformations using Hash file (lookups) and writes to Oracle .i use sequential file stage , transformer, hash file & Oci stage . I am just using KeyMgtGetNextValue routine in the transformer . when i double clicked the "From Previous run", ...

yes .
There is "from previuos run" entry in the log.

can you tell me how this helps to analyze?

Thanks
Paddu

Hi All, I did not find proper reason why the job aborts randomly with the error below and also with "Abnormal Termination of stage detected" . :?: opened ticket with IBM but no definite response :( ,waiting for them to get back to us. DataStage Job 348 Phantom 6404 Program "DSP.Close&...

Server is Windows 2003 and Client is Windows XP .

Hi All Job sequences we have about 20 Job sequneces designed in our project. when i try to open any of the Jobsequence ,the designer just blows up and forces me to close datastage Designer. Even it opens ,i cannot view the properties of the Job activity in the sequence . It was fine before when we d...

Issue Resolved . Somehow the job was waiting to finish the process and built the two flat files (even though the status was aborted in director ) .I truly do not know the issue why it did that :? . now after recompling the job it runs in 1 min and i can view the flat files too. Anyways Thanks for re...

I have a job which usually takes 1 min to run . Yesterday when i was running , the job just hangs. The job populates 2 Flat files and loads into Oracle using Link Collector.It hangs upto loading into flat files I stopped the job through dierctor. The flat files are locked . when i try to open them (...

[quote="ray.wurlod"][code]InLink.ZipCode Matches "5N" : @VM : "5N'-'4N" [/code]
used as a constraint expression or in an If..Then..Else expression ...[/quote


Ray,

thank you very much. i used the expression as constraint and it worked.


Thank You
paddu

i have a CHAR field , but i need to pull only numeric values or values with hypens only. It is a zipcode field ,so i need to pull values something like this 90062 or values with hypen like 90062-3214 . sometimes this field has values like , "extra","exist" etc... Zipcode field le...

The issue is fixed . The problem was in one of the staging table datatype(length) .

Thanks
Paddu

Hi All, my job is seqfile-transformer-orcale- transformer(hash file lookup)-oracle job runs fine upto first orcale (loads it) then i get the this warning and job aborts. DataStage Job 479 Phantom 7532 Program "JOB.1592299707.DT.1415445600.TRANS2": Line 155, Improper data type. Attempting t...