DSXchange

What does that message tell you?

Job properties.

To get there, click the fifth tool from the left in Designer (version 7.5 or earlier), press Ctrl-J or choose Job Properties from the Edit menu.

Does the fix_zero need to be in quotes? What do you believe that fix_zero does?

How are you storing it from the last job?

What precisely is your requirement? Write an accurate and complete specification of your requirement. You may be surprised; just doing that may make you think of a solution.

The wc command should give you three numbers. I am interested in all three. Assuming you have given me a character count, I observe that 396021830 / 4557 is not a whole number. But, when we allow for the line terminator character, 396021830 / 4558 is a whole number (86885). So that's the first of th...

There is even a Surrogate Key Generator stage in parallel jobs. The trick is to generate a sequence of values that is unique across all partitions. This you will discover how to do as a result of your search.

If one input has 90 columns, the second input must have 90 identically-defined columns.

You state that you create "dummy column" (singular). You need to create 89 dummy columns, not just one, before the Funnel stage will work.

1. Validate them, to ensure that the connectivity and SQL are still valid.

2. Test them.

You are right - mainframe jobs are restricted to what you can do on the mainframe using COBOL. Therefore, any decision making will need to be performed using DataStage components such as an External Routine stage.

WeekdayFromDate() will return the weekday number (based on your business rules for the start of the week). You first need to extract the date portion from the timestamp. Once you have the weekday number you can use Field() to perform a lookup from a string constant containing a delimited string of t...

This is a known issue when you have certain incompatible combinations of versions of client and server software. One known combination that will generate it is version 7.5x2 client and 7.5.1A server. Is the Palette totally empty or is there one icon that can expand to show all stage types? Is the St...

What is the size (in characters) of the MALADDR file?

Because the mainframe environment does not have the same "command line" concept as UNIX, your best approach is to pre-process the file with a very simple DataStage job that counts the rows (as described earlier). Park the row count somewhere (a file, probably) that you can read to make the decision ...

Have you tried it? I suspect there may be some issues because DB2INSTANCE environment variable can only have one value set at a time. There is a manual available (currently in its third version) on connectivity to DB2. It's an invaluable item of ammunition for your armoury. Search the forum to find ...

It's not a numeric loop you need here - it's the other one, a "list of things" loop. Your delimiter character can be specified as newline ("\n").
If the command is ls may I recommend the -1 option so that you get one filename per line in the output?