Is this a CFF bug?

ashwin2912 · Post by **ashwin2912** » Mon Sep 26, 2005 2:57 am

I am using CFF stage on Datastage 7.5

When I import a copy book with a PIC S9(n) field, it is imported as a "DISPLAY NUMERIC" => PIC S9(n) type field.

But when I press OK on this stage to save the changes and open the properties the next time, the same field shows as "DECIMAL" => PIC S9(n) COMP-3 type.

This seems to be a bug in CFF stage, as the file being written in such a way is of lesser size than that by a Sequential file stage (due to COMP-3 compression).

Has anyone come across this one? Or am I missing some option?

ashwin2912 · Post by **ashwin2912** » Sun Oct 02, 2005 10:11 pm

Pls find below screenshot on what is happening....

Before:
http://i23.photobucket.com/albums/b376/ ... Before.jpg

After:
http://i23.photobucket.com/albums/b376/ ... /After.jpg

Luciana · Post by **Luciana** » Thu Aug 23, 2007 1:16 pm

I have the same problem with one job that use Complex Flat File Stage. I import the table definition and one column appear as DISPLAY NUMERIC, but when I press OK and after open the properties, this column appear as DECIMAL. The job execute with no warnings, but the size of row stay incorrect.

DataStage Server: Aix 5
DataStage Enterprise Edition 7.5.2

Att. This problem happened in AIX. I executed the same actions in DataStage Server Linux (version 7.5.2) and no problem.

Can anybody help me?

Thanks,
Luciana

flashgordon · Post by **flashgordon** » Fri Nov 02, 2007 7:45 pm

Hi,

After fussing with CFF stage a fair amount I have strong advice for people. Don't try to edit cff stage inside the CFF Stage GUI. If you want to change something, clear the CFF stage, edit the copybook with notepad, and re-import the copybook. Editing the fields in CFF stage just doesn't work even though it should. I don't know if I could get Ascential to admit this or not. But I saw some incredibly bizarre things happen once I tried to edit a copy book I had already imported. If you clear CFF stage and re-import, it has no choice but to do what you specified in the copybook.

... Tom

flashgordon · Post by **flashgordon** » Fri Nov 02, 2007 7:45 pm

Hi,

After fussing with CFF stage a fair amount I have strong advice for people. Don't try to edit cff stage inside the CFF Stage GUI. If you want to change something, clear the CFF stage, edit the copybook with notepad, and re-import the copybook. Editing the fields in CFF stage just doesn't work even though it should. I don't know if I could get Ascential to admit this or not. But I saw some incredibly bizarre things happen once I tried to edit a copy book I had already imported. If you clear CFF stage and re-import, it has no choice but to do what you specified in the copybook.

... Tom

landaghaar · Post by **landaghaar** » Mon Nov 05, 2007 11:17 am

I had this problem. But you just convert the PIC 9(9) to PIC X(9) in copy book and reimport or just change it in the CFF gui. but just make sure once you do it, go to ouput and on the mapping click on << and then on >> once, otherwise you will read as a char but will try to write it to output as COMP-3 which will screw up.

max.madsen · Post by **max.madsen** » Fri Nov 09, 2007 2:40 pm

I think it is a client bug. Update DS Client to 7.5.2 version and try again.

flashgordon · Post by **flashgordon** » Fri Nov 09, 2007 7:05 pm

Max,

Thanks. That's interesting. I thought we were pretty current and we're 7.5.1.something. How long has 7.5.2 been out?

... Tom

ray.wurlod · Post by **ray.wurlod** » Fri Nov 09, 2007 7:38 pm

Quite some time. Indeed there will be a 7.5.3 late this year or early next year, according to the roadmap presentation at IoD 2007.