DSXchange

We have promoted some jobs from the dev through test environments with no issues, but on the production system (with even more memory/CPUs) using higher data volumes we are getting a somewhat sporadic problem while running a job which reads about 8 sequential files; this occurs in different location...

Do a "UVFIXFILE {yourfilename} " and it will tell you what you want to know.

Doing a RESIZE on an empty file will not change the size (Hence the 8Kb in both cases). Put some data into the file and then do a before/after compare of the RESIZE results.

ANALYZE.FILE is a standard verb in the VOC, if it is missing then you have removed this (and perhaps other) VOC entries - which might cause problems in DataStage; the VOCabulary file is the crucial file from which everything is ultimately done; you should be very wary of modifying this file. If you ...

The logs are stored in internal HASHed files that you cannot read directly. The best method to get the logs from the system is to use the "dsjob" command options, start off with "logsum" (log summary) and work your way to more detail and to that level of detail that you wish. You can also search the...

Clarcombe,

DB/2 can have CHAR(000) padding, which a TRIM() doesn't remove. Do a LEN(YourString) and it will probably be 3 when you expect 2.

CONVERT(CHAR(000),'',YourString) should remove this.

Wow - many more responses than I had expected! I think one part that I didn't really stress is important, otherwise I could have used DS's PX facility of not having to declare DB columns - each column needs to have a transform applied to it. The table & columns are the same, but the datatypes ar...

Pongal,

The quotes inside strings read from CSV files can be changed from 1 to 2 via a EREPLACE('"','""',In.MyColumn1) derivation; the outer quotes in a csv file string are part of the file's definition and metadata, so you can only modify those in the sequential file stage definition.

Morning Clarcombe, your 2-charactervalue-in-a-3-char-field is going to be padded with either a space or some other value. Hash files are always varchar, so the third option exists with the field having been trimmed when you created it. This, of course, depends upon how you created the hashed file. I...

Anup,

normally you can quote the string in DataStage as well. In which part of which stage are you having errors, could you provide that plus the error message?

-Arnd.

I have a requirement that has me taking about 400 DB/2 tables and loading them into Oracle tables with the same table names and column names. The datatypes are being changed (different date handling, some trims, nulls modified, etc.) according to rules based on the datatypes and not on the column na...

Sunshine, the advice you got so far will work as listed; you have changed this (from an external call into a TCL one) so it won't work and the message clearly states the syntax error. The concept in UNIX and DOS of using a ">" to redirect output does not work in the TCL environment. If you really wi...

In my environment (UNIX) I used


successfully.

That should give you enough to get it working.

Ashwin's line looks correct. If the redirect to the text file is working correctly then you should get no output to your terminal, just to the file. If you are having problems with this you need to post your exact command here or talk to someone savvy in UNIX locally.

No, they are encrypted so that this is not possible.