DSXchange

Hi Franklin, We figured out the issue. Instead of sending file over email we SFTP'ed the file to the mainframe server without a delimiter in the CFF stage. The mainframe program was able to recognize the negative and positive fields. Issue = resolved. Thanks for your help! Always appreciated. Jared

Franklin -

You are correct...

The 0D is coming over in LineFeed (LF). When I view the file in notepad++, there is a break in record.
Is there a way to get rid of this? Or no?

Please advise!

Thank you.

Hello All - I am having an issue with some negative packed decimal fields in the CFF. Job Design: Seq. File -> Transformer -> Sort -> CFF The CFF Stage is packing the data. I have two amount fields within my source. Both of which are [15,2] - PIC S9(13)V9(2) Comp-3. A source will read as followed -0...

Thank you for the advice! I will be sure to follow it in the future designs.

Regards,
Jared

Craig -

Got it!

In the transformer stage I was using Div(Amount,100).
I switched it to (Amount/100) and it worked!

Thanks for your help,

Jared

The field is defined as a decimal across the 2 remaining stages (Sort & CFF). ** I did notice something interesting though. I removed the amount field in the CFF Stage (which is the final stage in the program). Then I put it back into the CFF stage. Once I carried it over from the sort, I notice...

Craig -

I did read this on another thread, and it is working to an extent.

However, it doe not work when there are cents involved.

Ex. 1015.00 should be 10.15
This value shows up as 10.00 once I divide 1015.00 by 100

All - I did some research and found the OCONV conversion. However, when i go to use it in the Transformer Stage it does not work. Shows up as a red error when I leave the derivation box. Ex. OCONV(DOC_AMT,"MD22") The "DOC_AMT" field is a decimal, length 15 scale 2. Please advise,...

In the CFF Stage under 'Record Options' Tab there is a default values column. Enter 0.0 as a default.

Ray - Here are what the column grid fields contain: Level Number = 2 Column Name = Amt Native Type = Decimal Extended = Length= 15 Scale = 2 Nls Map = This is a signed field so the picture clause = PIC S9(13)V9(2) COMP-3. Is there something under the extended attributes section which I should be usi...

ArndW:

The packed output file is being sent to a mainframe program. I have been working with the mainframe team throughout the development. A member of the mainframe team made me aware to this decimal location issue.

From what you said, it sounds like the assumed decimal position is off.

Hello - I am having an issue with packed decimals in the CFF Stage. First here is some background on the job design: - Bring fixed length records in via Seq. File Stage - Parse records based on byte order - Sort records - Pack records in the CFF Stage Issue : - The only fields I am having issues wit...

All -

I wrote the header/trailer records to separate files.

Then I wrote a bash script and created a subroutine which 'cat's' all of the files together.

Thanks,

Jared

@Chulett -

Worked like a charm! Thanks for your help.

Jared

Hello -

I am trying to convert a string(which is a date) YYYYMMDD to YYYYDDD.
The YYYYDDD columns need to remain in a decimal format since this field is going to be packed in the CFF Stage.

Please advise.

Thanks,
Jared