DSXchange

My bad . I was focusing on the field the data would go into, not what it was in the file. Sorry if I mislead anyone.

John

It sounds like your datatype is wrong to me. A PIC 9 would be an integer, not binary. In the subject you say PIC S9(7) which is a signed integer seven long. In the body you say PIC 9(10) which is an integer 10 digits long. You need to decide which it is and change the CFF layout accordingly.

John

... back to the original question. I have yet to find the transform function I had for writing a packed decimal field. I will continue looking. Does anyone else have any help?

John

I have seen something like this happen if the &PH& directory is not periodically cleaned out. Search the forum for the right way to do it.

John

Yes, Craig. The CFF stage can be used as a target in a parallel job.

John

Just a couple of clarifications: 1. the CFF stage cannot be used as a target in the Server edition - it does not support input links. 2. you can write a packed decimal using the sequential file stage, but it will involve a DS Transform call or a routine. I've done it before but I don't have the code...

You could try:

DATE[7,4]:DATE[1,2]:DATE[4,2]

The DATE I am referring to is the name of the date field coming into the transformer.

John

You could perform something in an After-job subroutine to delete the file if it has 0 bytes.

John

Sounds like a permissions problem to me. What are the permissions on the IVVM.LIC and DDVM.LIC files and the directory they are in? Can the user you log into Manager with get to these files in a telnet session?
John

You are right, when I highlight a parallel job in Manager the Release Job option is greyed out. When I highlight a server job, it is active. The Package Installer historically was in the Server edition, so I suspect they never upgraded it to install parallel jobs. Your other options are to use the V...

I don't use Sequences much, but I would pass everything as a string then use the Oracle TO_DATE function in your query.

John

I can't say exactly for 8x, but in earlier versions, you are trying to use the Dependencies information incorrectly. The 7.5 Server documentation says: The Dependencies page specifies any dependencies that the job has. This is to ensure that, if the job is packaged for use on another system, all the...

What kind of file is it? Can you open it with a text editor like Notepad? From the Import from file dialog box, you can change the file type from *.cfd to *.* then you should at least be able to see it. That's not to say it will be imported properly.

John

Where are you putting the data...in a database, in a sequential file? The solution depends on your target.

John

Now I understand. It is looking on your workstation, not on the server. Move the COBOL CFD file to your workstation.

John