Anyone has encountered this problem before.

bala_135 · Post by **bala_135** » Mon Mar 24, 2008 1:53 am

Hi,

I am trying to change the Quote character from " to 000 in a sequential file stage(target).When i do this and compile the job again the following error message appears.
Active stage has no output columns

I understand this error message but the column definition automatically goes off.I am not deleting it.Kindly let me know anything can be done for this to get back the original job or if it requires re-indexing how can i do it for this job alone.Any help is most appreciated.

Regards,
Bala.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 24, 2008 2:01 am

What exact version of DataStage? I can not reproduce on 7.5.2 on a Windows platform. Does reinstating the quote character magically reinstate the link definition?

bala_135 · Post by **bala_135** » Mon Mar 24, 2008 2:54 am

Hi Ray,

Apologies for not let the version correctly it is 7.5x2.Yes you are right that is what is happening.

Regards,
Bala.

ArndW · Post by **ArndW** » Mon Mar 24, 2008 2:58 am

It seems that DS is inserting an active stage before the sequential file. Try adding a dummy transform stage to see if this behaviour changes. I assume the stage leading to the output is a passive one - is that right?

jdmiceli · Post by **jdmiceli** » Mon Mar 24, 2008 3:24 pm

Please pardon my ignorance, but is it wise to replace a quote character with a 'nul' character (not NULL). I believe I heard Ray comment on that once and wanted to make sure I understand for my education as well.

Are you doing the replacemant a Transformer Stage in a derivation or something else?

You could issue a command against the file at the shell level as a 'before job command' to do the replacement. Since MKS toolkit comes with the DS install for Windows, your command would look something like

Code: Select all

cat filename | tr/\"/whatever/g >> new filename

You may have to tweak the syntax as I'm just pulling this out of my head.

Of course, if you have Perl available (come on, Craig knew I would do it!

), then you can just do it like this:

Code: Select all

perl -pe 's/\'/whatever/g' filename.

Hope that helps!

bala_135 · Post by **bala_135** » Tue Mar 25, 2008 10:52 am

Hi,

Thanks for the command.I am not doing anything at the transformer level only at the target stage changing the Quote character from " to 000 in the format tab of the sequential file stage.My concern is about the strange behaviour of datastage.Just want to know the ghost

behind this action.Anyways will look into your code as well.

Regards,
Bala.

chulett · Post by **chulett** » Tue Mar 25, 2008 11:38 am

For strange hauntings you'd need to go back to IBM Support, they are the official Ghost Busters.