DSXchange

Use a DataStage sequence to control which tables get copied.

Start only the sequence from the third party scheduler (Autosys).

Much cleaner.

In the SIT environment D_DS_AUDIT is clearly NOT read-only, since the I-descriptor (INSTANCE) compiled successfully.

Please compare D_DS_AUDIT carefully between the two environments.

You might try compiling the I-descriptor manually. The command is

Netezza uses temporary work tables (TWT). Is that what is unclear?

So is it that you want a new file to start each time a line beginning with "A" occurs in the source file? This might be easier and faster to accomplish using a stream editor such as sed or awk. If you must use DataStage, set another column to flag whether the "A" appears or not, ...

Best help is from Dennis James (editor@dsxchange.net)

Note that this is a .net address, not a .com address. dsxchange.net is the commercial side of DSXchange.

Welcome aboard.

Since AMERICAN_AMERICA.US7ASCII does not support Arabic characters, it's not clear to me how you're getting Arabic characters at all. Can you be more precise?

What happens if you try reading with AMERICAN_AMERICA.AR8ISO8859P6 as the character set?

Is the queue manager installed on the same machine as the DataStage engine? This is a requirement for server mode.

While browsing, I found that incase Datastage Login happens via Active directory then Username and password is not required. That is true ONLY IF both Information Server and the engine tier operating system share the same Active Directory (or other LDAP-accessible user registry) and that shared con...

Why not look at the segment files (using the Data Set Management tool in Designer) to try to work out where the differences actually lie? In particular, review how many 32K or 128K blocks are involved for each Data Set. Space in a Data Set includes any unused space in these storage blocks. It may be...

Was A.ds populated in one go, or by successive appends?

Looks like orchadmin cp has taken the chance to effect reduction of un-needed space.

I guess I can upload that on the weekend.

If anyone needs it urgently, email me through DSXchange.

Looking forward to the holidays so I can spend some time getting the website beyond "under construction".

It is a requirement for Information Server that every computer on which any Information Server software is installed has to be able to resolve its host name to an IP address.

Not if you insist on using RCP throughout. If you want to apply a transformation to a column, you need to name the column (field). DataStage adds leading and trailing non-significant zeroes to Decimal numbers to assert/prove the precision and scale values. This behaviour is not (currently) negotiable.

Timing?

Curious. You are marked as Premium User. Has your subscription expired?