DSXchange

Well, I was looking for an editor integrated within datastage. I used to use VI editor in all my earlier projects and didnt feel the need of one. But in the new project its a secured and restricted environment where in I cant access anything outside datastage. So, Was just checking if there was any ...

I wish there was a text editor to manage, view or edit files so that its easy to manipulate the files. Am I missing out on something that I dont know?

Hi, Well, We are getting files with compressed character fields from assembler programs(theese are not COMP-3 fields) which when we try to read through data stage shows junk characters. the character set is EBCDIC. hence, to read it properly we have to read these fields as ascii(we define this in th...

We are able to find a work around. we had to use a sequential file stage(it still doesnt work with complex flat file stage). this is the solution for the future use of the the forum users. 1.using sequential file stage defined the decimal column to null(this is not allowed in cff stage). and packed....

this is what I have tried: 1. tried defining \x00 as a default value when there is a null(still the sign bit remains as it is) 2. as you had suggested in one of your earlier post to concatenate the char(0) values even this doesnt work. 3. then I tried redefining the column using the complex flat fil...

well, this is just an extension of it. I have already searched and tried the solutions provided in the earlier posts but nothing seems to be working.

yes, thats right. they just need the low values but the issue is for null in comp-3 it would write zero's with a sign bit(like C, F or D) which they dont want. at times whenever it is null they want just zeros without the sign bit(so that they would be able to distinguish between the actual zeros an...

Thanks for the reply. I almost thought it went unanswered.

Well, all I need to do is write the data in the target file in COMP-3 format. incase, if the field has a null value then I would want to write in a character format(tried redefining, didnt work )

craig I tried searching the forum but with no luck. well, It does mention that redefines are not allowed there but doesnt really give any clues like why not(I have already checked the level is the same, the length is equal to what is being redefined). Would it be possible for you to help?

Thanks!!!

Hi, I am trying to redefine the columns in the target complex flat file stage but it is giving me the below error. Error when checking operator: At field "XXXXX": "redefines" property cannot appear in an export schema I am trying to write a value in comp-3 field. incase, if it is...

Hi,

Is there a way to define a field delimiter in CFF stage? If yes, then please point me the place to do that?

because that is how the source team defined it. I dont understand much about it so I might not be wording it properly. However, Please refere to the link Link http://www.simotime.com/datapk01.htm In the second table it has defined the positive and negative Hex data. which I am not able to read using...

Hi - How do we handle the comp-3(packed decimal) with hex data in complex flat file? is there a separate option to handle this ?

[* Note - Title changed to be more descriptive - Andy *]

Thanks ray!!! well, I could find the documentation of basic. well, was looking for one in parallel.

Hi - I have been reading that lot of server routines can be called using a basic transformer. However, in most of the environments I could find only one transformer and I couldn't call the server routines from that. Could you please guide me where I should be looking for the basic transformer?