DSXchange

FYI - Your first TRIM makes no sense as it trims the result of the entire expression, meaning it resolves to a 0 or a 1 and then you trim that.

i fired this command which gcc, i found the directory of compiler. /usr/bin/gcc i added this to my PATH in datastage administrator. Just an FYI - you should have been looking for the compiler itself so it would have made more sense to run which g++ to see if it can find it and where it found it. Th...

srinath0253 wrote:Error when checking composite operator: Output from subprocess: sh: g++: command not found

It simply can't find your compiler. Double-check where g++ actually lives and make sure that is in your PATH. That or correct the name of the compiler.

Sorry, just meant as in 'at the end of a sentence'. Was just trying to point out that your first post is one long run-on statement.

smohd1338 wrote:what are periods and how can i use them, ?

You only would need to recompile the Sequence if A) it changed or B) the parameters for one of the jobs it calls were changed. As already noted.

Really, you'd do basically the exact same thing. However, I would guess you'd just need to check the first field rather than substring anything but that will depend on how you have defined the file metadata.

Also... periods are your friend. Don't be afraid to use them.

No clue. Hopefully by now you've opened a case with your official support provider, yes?

They did. Well... except for the first reply.

OK. Have you verified that the compiler does in fact live in "/usr/vacpp/bin/xlC_r" with the appropriate permissions and that the options you specified are in fact correct? Also note the link you posted may be to an official IBM compiler, but you need to verify that it is actually supporte...

No, since the job would not have started at the time you assigned the parameter. Simply assign the current system date/time instead. Another thought would be to split off another link from a transformer in the job and set the link order to be 1 so it 'fires' first. Use the macro there to set the val...

It wasn't possible to tell what kind you needed based on the information you posted, so we really couldn't tell your type might be wrong. Think of it this way: 1. Source: Feeds data into a job. Only outputs data, does not consume / take any input data other than parameters. 2. Target: Consumes data ...

So, it's not so much that the transformer is not working but rather you cannot compile a Parallel job that includes a transformer stage. First question - since I have no idea - is the compiler you installed an official supported compiler for your platform/release?

OK. As noted, one option would be to pass that value in as a Job Parameter and then bind the parameter into the SQL.

Again, you can't. You can reference job parameters there but not row data of any kind. My answer was based on me thinking that you wanted to set the value of a column to "dsjobstartdate-1" during the load for all records as they were loaded. Is that not the case? Do you really need to load...