DSXchange

ray.wurlod

It appears that the example comes from a NAME rule set, so it's unlikely that multiple numeric tokens would appear (although, of course, there is a possibility). We need to await a response from U.

ray.wurlod

One stage variable to detect change in the key column.
One stage variable (later in the grid) to remember the key value from the previous row. This is used by the first stage variable.
One stage variable to increment/reset the counter.

If you Search DSXchange you will find examples.

ray.wurlod

Use the decimal code for the space character (032) in the delimiter field on the Format tab. (You can use hex but must prefix it with "&x", for example &x20.)

Export all the "dead" jobs then delete them. Make sure you keep the export file in a safe place.

ray.wurlod

Code: Select all

cd `cat /.dshome`
. ./dsenv
dssh "SELECT SCHEMA_NAME, PATH FROM UV_SCHEMA WHERE SCHEMA_NAME = '<<Project Name>>';" << eof
QUIT
eof

Redirect output of dssh to a location of your choosing.

ray.wurlod

What you were told is correct when the DataStage server is installed on a UNIX machine, because SQL Server does not run on UNIX. However I note that you have marked your server type as Windows, in which case you get both the Connector and the SQL Server Enterprise stage.

ray.wurlod

It means that you are logging in using a user ID that has not been given Suite Administrator credentials, only Suite User.

ray.wurlod

Unable to load dependent module usually suggests that your shared library search list (LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH environment variable) is not correctly set.

ray.wurlod

Yes.

But you're not allowed to lie. DataStage checks at run time!

ray.wurlod

If the data type is Date, then conversion is neither required nor possible. If the data type is string, then you can use StringToDate() to convert this to a date. If you require the output also to be of type string, then you can apply the DateToString() function - though with a different format stri...

ray.wurlod

Use Director client. Job menu, Clear Log option.

ray.wurlod

Has your user ID been correctly set up in Web Console for Information Server?

ray.wurlod

No. You must run the job (for example using dsjob command). The OSH generated by compiling the job is never what gets executed. In contains no information about parallelism. The first process to log in reads this osh script AND the parallel execution configuration file, and composes a new script cal...

ray.wurlod

$_ is a standard shell variable - the command you are executing at the command prompt.

It's in a family with others such as $$ (current process ID) and $? (exit status of prior command).

Read the man page on sh or any reasonably UNIX beginner's book.

ray.wurlod

Or even

Code: Select all

Ans = Output<1>

or

Code: Select all

Ans = Convert(@FM,"",Output)

ray.wurlod

... but lose the semi-colon after QUIT

DSXchange

Search found 53125 matches

Re: Calling OSH script from UNIX Server