DSXchange

Is it not possible for you to use a BASIC transformer and make use of IConv/OConv?

What is the issue here? The value you see in mainframe is in Hex. When you import the proper copybook to CFF, and the data you will get will be the equivalent decimal value.

Will that be possible if we use ODBC stage to read a sequential file? I'm sure we can use ODBC stage to read a sequential file, I even tried but couldnt make it to work.

I believe the pallet will be available only when you have a job open.

I have the same issue and I found that the Num() function in the stage variable creates this error. If I take that out, the job runs fine. Anybody have a solution or work around for this?

Create your target file normally, like one output for an input. In the next step (Same or different job) read the whole record as one column, create a target file with 30 columns as pass the source value to all the 30 columns and for the first 29 columns append the Line terminator as required.

I assume that your file will have a " and Line termonator at end of each record. If so, Say if your file has DOS terminator, try to read the whole file using a folder stage, pass it to a transformer, replace all the " and DOS line terminator to " and UNIX line terminator and pass it t...

Check if you have the right copybook and the file. This error mostly occurs when the data in the file does not match with the copybook.

You can also verify the file and copybook by importing them to mainframes.

Is that happens only to a particular job or to all of the jobs? Did you try creating a new job? Is that the same?

Check if you have the same file format and the line terminators in both of them.

You cannot generate the numbers like how you expect with this. I have tried before but did not work. You should run the transformer sequentially. And when you run like that, you dont need to use this formula, you can just use @INROWNUM or @OUTROWNUM.

Read the entire record as one single column (With the length you think will be the maximum) and route it as required in a transformer with constrains A1/A2 etc., if thats all you need to do.

Add a parameter to you job, and pass the value (job start date or current timestamp) from the sequence and append the parameter to file name as required.

Well, you are not trying to write it to a output file in your command. Try this:

ls -a /data/DataStage/OPTICOM/SRC_FilePattern* > /data/DataStage/OPTICOM/FileNames.txt

Its a UNIX command to list the files in a specify path or current directory. And YES, you have the command activity in the job sequence to execute any command/script.