DSXchange

No idea. Stay tuned.

You really should have asked this of the Membership Director.

Hint: Investigate a bit more what information goes to stdout (file unit #1) and what information goes to stderr (file unit #2) from the dsjob command.

Assuming default installation location, /opt/IBM/WebSphere/AppServer/profiles/default/logs/server1 is where the main logs are. You're most interested in SystemOut.log and SystemErr.log.

Apart from that what changed?

string_trim() is a function one uses in a Modify stage.

The other five trimming functions are used in the Transformer stage.

Details can be found in on-line help or in Appendix B of the Parallel Job Developer's Guide.

Hi It may not be the straight forward way. But you can try something like below! Use the sequence for looping. Using the DCOUNT function to find how many iteration it need to loop and based on that you can try to do something. DS User That would be woefully inefficient. The task is to process the c...

What exact version of InfoSphere Information Server? The path is different between version 8.1 and version 8.5.

This is an ideal application for the looping capability that exists in the version 8.5 Transformer stage.

I'd use a DataStage job that loops through the stage/link names to produce the row counts.

If you insist on doing it through a routine, then you need either to execute a BTEQ script from that routine or find some other way (such as BCI functions) to write to the Teradata tables.

Think CAREFULLY before you just turn that last option on, it will affect ALL washed files created afterwards... all, not just ones your jobs may use. Search here for many discussions to that effect. Not just washed files, but hashed files too. :lol: I believe that this is poor advice from IBM suppo...

If the worksheets already exist, and conform to the requirements of the ODBC driver (column headings, mainly) then you can write to these sheets using an ODBC driver for Excel. However you may not have one of these on a UNIX box. Only one Excel worksheet can be imported from one CSV file. Therefore ...

So you're looking for a running, or cumulative, total. This is easily accomplished with stage variables. Many examples have already been posted on DSXchange.

If you enter the command dsjob with no arguments, it will display a list of available options at that level. You would discern from that, for example, that the option of a list of projects is -lprojects. If you enter the command dsjob with a major argument, such as -run, but no other arguments, you ...

You should not need to recompile unless you have introduced that environment variable into the job as a job parameter (and have not set its default value to the special value $PROJDEF).

Job parameter values are reported into the job log. User variable values are not, but that doesn't matter if you've passed them as job parameters.