DSXchange

Arnd, you mean I should use COMP-3 rather than PIC(X) in DS ? But COMP-3 with no sign still have a 'F' in lower byte, but I don't want this sign. Am I mis-understanding your meaning ? Benny, my point is that your method takes whatever bit representation the COMP-3 field is using an breaks that up in...

ArndW, Actually it is an output file (we need to ftp DS sequential file to M/F), and our COBOL Macro doesn't have redefines for this field (redefine only code in COBOL PGM) Benny, the COBOL redefines shows that you don't need to do any conversion at all - in the job input file column definition tell...

In my case, I would like to convert decimal to EBCDIC character and then ftp the sequential file to M/F. Objective 6 bytes 3 bytes 7 bytes 4 bytes --------------------------------------------- 123456 ===> 135 1234567 ==> 0246 246 1357 In M/F, it is quite a easy job, MTCH-KEY C4V1-3 FILLER R MTCH-KEY...

Hope it is what you wanted. record {record_delim='\n', delim=',', quote=double, ascii, text, zoned, leading} ( Col1:string[40] {delim=',', quote=double}; Col2:nullable string[3] {null_field='\xFF\xFF\xFF'}; Col3:nullable decimal[17,0] {zoned, leading}; } Hi First check your source file whether you h...

That means "Null Field Value" can be setup within Schema file ? If yes, that is great. I got the answer. record ( lastname: string[16]; middlename: nullable string[3] {null_field='\xFF\xFF\xFF'}; firstname: string[16]; ) The word "nullable" would be a good start. record ( lastnam...

in which keyword should I search ? There are lots of doc about sequential file stage in this forum. Would you please show me some links.

Thanks a lot !

roy wrote:Hi,
You can try solving this in the sequential file's stage configuration.
this was covered extensivly please search this forum.
IHTH,

I have a simple job contain only one Dataset stage and one Sequential File stage, what I want to do is DS --> SF. And I would like to make this job reuseable for all file layout. So I use the "Schema File" property to setup the schema in Sequential File stage. However, there is no null fie...

kduke, Actually, what I encountered is the checkpoint was erased. I am getting puzzle for a long time. When you go for ""Reset if required, then run" this option , when there is an abort even the checkpoint will be erased. This is not true. We do this all the time. It should only run ...

Yes, I am finding it in Server machine. And the plug-in stage exist in both server and parallel. As I remember, when I install the DS in server machine, I don't have specified any option about that. Besides, I can't find the DLL file in my client machine. And when I go to Tools menu > Register plug-...

Ray, I can find the FTP Plug-in stage in the panel, so does it mean it is already registered ? From the properties of the FTP Plug-in stage, the DLL name show as dsftp.so rather than dsftpune.dll. So do they the same Plug-in ? I have tried to use that FTP Plug-in, but it will fail when processing a ...

However, I have encountered another case Options: Add Checkpoints so sequence is restartable on failture (ON) Automatically handle activity that fail (ON) In my previous case, I have used "Exception Handler" and "Routine Activity" (call DSJobAbort) to force the sequence aborted i...

oh, yes, I know what is happening, the sub level sequence has been reset, so that it start from the beginning. That means for sub level sequence we should set the option "Run" instead of "Reset if required, then run", right ? Ok and do the log shows they have been reset when you ...

Yes, the aborted job can be reset automatically, because I have set the option "Reset if require, then run"

roy wrote:Hi,
Do you see the jobs getting reset before running again?
When they are in aborted state do you see only reset option in director for those sequence jobs?

yes, all lower level also enable Checkpoint restart

ray.wurlod wrote:Looks like you only have Checkpoint restart enabled on the top level job sequence. What happens if you enable it on lower levels also?

No, I am working on DS7.1, but failed

kduke wrote:What version of DataStage because this works fine in Ds7.1 and above.