DSXchange

ray.wurlod

It's in my 7.0.1 on WinNT. However I've been having an offline exchange of private messages at ADN with someone from Ascential who says it isn't. Stay tuned...

ray.wurlod

The code looks OK. Put in some extra logging statements to diagnose what path is being taken through the code. In particular, determine why job2 isn't starting.
Are any abort messages (red icons) logged in any of the three jobs?

ray.wurlod

NLS is National Language Support. It's not necessary for European languages. If you have it enabled, most of your passive stage types will have NLS tabs. That you ask the question suggests that you do not have it enabled. EN_US tends not to support accented characters very well, as US English does n...

ray.wurlod

Do a search for PWD. This has come up before.

ray.wurlod

On what basis do you want to "bring them together". Is there some "key" value that you can use to "join" pairs of files, or do you just want all the columns from line 1 in file 1 then all the columns from line 1 in file 2 then all the columns from line 1 in file 3 then all the columns in line 1 in f...

ray.wurlod

Do you have NLS enabled? The answer will be different depending on whether you do or you do not.
What is the value of your LANG environment variable on the server?

ray.wurlod

Looks OK to me. You have the two "D_" prefixes where needed. The fixed pathnames mean that it's not very portable. Perhaps you could use job parameter for the hashed file directory. Similarly, the pathnames of the executables may vary when you promote from development to testing to production. The h...

ray.wurlod

I think you can. DataStage 7.0 does not use /.dshome but uses the environment variable DSHOME instead, to determine the location of the DSEngine directory on UNIX systems. Which is kinda tough if it's not set in your .profile and you have to find it! On 5.2 shared memory keys have the form 0xdaec961...

ray.wurlod

Sure you can.

Use oerr -01036 to find out, or consult the Oracle codes and messages manual. It's an Oracle error, not a DataStage error.

ray.wurlod

Job0 is a controlling job (or job sequence) that runs Job1 then Job2. Job1 puts the value somewhere, perhaps its user status area, perhaps a text file. Job0 reads that value and uses it to set the parameter value for Job2 before running Job2.

ray.wurlod

Code: Select all

If data_suitable_for_StringDecode Then StringDecode(data) Else default_value

ray.wurlod

Code: Select all

Field("10|20|30|50", "|", inlink.A, 1)

or, slightly more robust,

Code: Select all

If (Num(A) And A > 0) Then Field("10|20|30|50", "|", inlink.A, 1) Else 0

ray.wurlod

Not quite correct. The second mkdbfile needs to create the file dictionary, and the UVWrite needs to write the @ID record into the file dictionary. * Not initialised. Attempt to open the file. Initialized = 1 OpenPath "/myPath/myHashFile " TO SeqFile Else EXECUTE "CSH /bindir/mkdbfile...

ray.wurlod

ALL jobs are "phantom" jobs. "Phantom" is the DataStage term for background process. The status you see in Director is a record from the RT_STATUSnn table for the job. It is not necessarily the actual status of the job. If the job was terminated abnormally, then it may not have had a chance to updat...

ray.wurlod

A string of one or more space characters should be legal as a key. What does your support provider say?

Search found 53125 matches