DSXchange

The IBM technote on the warning message (not an error) says it's just a warning and should not effect execution. Although I can see how unexpected warnings could throw off a sequence job. Is this a new warning that started coming recently? I wonder if the admin were in some unusual directory when st...

It may also help to debug your script by redirecting its output to a new log file. Then you can check in the log file for clues.

No spaces in ServiceName: ServiceName=XXX You can setup an ODBC connection without installing the Oracle client or its TNS entry. Even if you configure ODBC correctly, you may still be unable to connect if there is a firewall blocking that connection. Make sure the firewall is open between your serv...

Yes, or install 8.5 Fix Pack 3 which would include the fixes in Fix Pack 2 also. Install on all server and client tiers.

To update the animated welcome message:
- Find someone who knows Adobe Flash
- Save new Flash file as 30000_Text_Fall.swf
- Upload to home directory

Oracle Advanced Security can be installed on any one Oracle database by itself. Ask your DBA if it's installed and requires encrypted client connections.

Try using the sequential file stage line terminator setting in a server job.

Ah, I missed the whole point about the zeros after the decimal; had only noticed the complaint about leading zeros.

Ray's earlier suggestion keeps the order.

ray.wurlod wrote:Make sure to run this Transformer stage in sequential mode.

When a parallel job runs on multiple nodes, the data gets partitioned (buckets) and sort order is not guaranteed.

Just to confirm, the suppress option works as expected on version 8.7 (tested). Field function is not necessary. Am wondering why it doesn't work as expected for others.

ssnegi:

0, 1, 2 don't carry any meaning; points lost for lack of readability...

@TRUE and @FALSE can be understood by anyone who touches the job.

Start to think beyond 3 days and beyond yourself for ongoing maintenance.

When tsort or psort executes in sequential mode, it's called a total sort. When tsort or psort executes in parallel mode, it's called a partition sort or a parallel sort. When you combine a parallel sort with a sort merge collector, it's called a total sort. Records processed by psort must be less t...

APT_RDBMS_COMMIT_ROWS appears to be specific to DB2. Are you saying that solved the problem or asking if it will? Feel free to test it by loading many rows. Open a database session and select count(*) several times while the job runs. Does the record count increase only once after the job completes?

The process(es) for each stage will start up and run in parallel, whether or not a given link receives data or is constraint-disabled to not receive any data.

Splitting the job into two is a good solution. It leaves you with two clear job designs.

With the FTP Enterprise stage, you would need a static, "dummy" data file to get every time. The "Open command" property, under the URI property, can issue the nlist command before it gets the dummy file. nlist syntax: nlist remote_directory local_file The local_file argument sho...