DSXchange

Apologies Ray - I simply hard coded the value I wanted to convert into a variable and then read the variable value into the function which worked.

Arg1 = "\"
Arg2 = EBCDIC(Arg1)
Ans = Arg2:"Doohhh"

I have resolved it!

I am wanting to concatenate the product of the function Ebcdic(@) to a string.

I get the error 'No closing quote' which I assume is because I need to protect the value returned from the function with quotes. How would I do this?

Any help appreciated.

Thanks for the help Ray. Using Iconv(TheString, "MX0C") rather than "MY" returns the same result. The data is in a sense manufactured. What I was trying to do was to create a flat file to transfer to mainframe (using binary mode), parcelling up one of the fields containing signed...

I am trying to convert a string of hexadecimal values into their relevant ascii characters. Oconv(HexString,"MY") where HexString = "414243" The above works fine returning ABC as expected. Oconv(HexString,"MY") where HexString = "00414243" This however returns...

Thanks for the help guys!

I simply want to pad a field with a number of leading zeros but the specific number is the value of an argument passed to the code. I have tried PadUnSigArg1 = FMT(UnSigArg1, "Arg1'0'R") which does not work and PadUnSigArg1 = 0(Arg1 - Len(UnSigArg1)):UnSigArg1 which almost works 0.00000001...

Cheers both of you, am now well tanned and able to give a proper response. I had thought of the csv option but want something that requires a transparent implementation for developers. I have gone down the reverse engineered hack before and wanted something easier, still it looks like the multivalue...

Quick question as its late and I want to sit in the sun (rare in UK) For reasons too tedious to go into , I am writing a small after routine that needs access to the Names of columns in a sequential stage. I have been using the DSGet***Info routines to 'navigate' to the relevant stages but cant seem...

Thanks, Havent got row buffering on and have removed lock for updates,but Still having problems , just to clarify my understanding If using Lock-for-Updates on the first HF , do I have to do anything special on the downstreams stages to ensure that an 'update lock' occurs as currently I am still get...

The answer is probably yes, but I will ask the question anyway I have a job that has a stream link into Transformer1 that does a lookup against a HashFileStage (HFstg1), if a record is not found I pass the data out of Transformer1 into Transformer2 to do some jiggery-pokery and insert the record int...

Hi, I am trying to read a file from a seq stage in PX , the file contains numeric (int,decimal) values that have spaces to signify nulls. Is there an easy way to 'map' spaces to nulls and avoid a record going down the reject link without going via a tranformer first. Sorry for such a basic question,...

Basically thanks for the replys, good to know that I can crib ideas of more experienced people - keeps me in a job :) . I downloaded the the sample job from Ascential which mirrors what I was trying to do but begs another question. I want to make this a generic module, and feel I can do this by acce...

Hi, I am VERY new to DS but would appreciate view as how to handle changed data detection using datastage, I have prototyped a job to use CRC32 on a concat of the non-key fields from a hash-file derived from target table, but need a way of generising this so developers dont have to re-invent the whe...