DSXchange

throbinson

Craig must be on vacation. What is athe ASCII value of the special characters you want to reject? Find that out and only write records that don't contain them. Write those that do to the reject link. '?' just means the character is unprintable. You need to replace the '?' with the ASCII value (CHAR(...

throbinson

In UNIX script interrogate for a file that has more than one line, like;
LINECOUNT=`/usr/bin/wc -l <file>`
if [[ $LINECOUNT -gt 1 ]]; then
mail it.
fi

throbinson

You've got a single job with 25 OCI stages all retrieving data? Hunh. RE#4. Arraysize. I did something really strange, I looked it up! Too high and you'll blow the buffer and the job will fail. This is dependent on the number of columns and their datatype sizes. Putting aside your fundamental questi...

throbinson

Example;

Code: Select all

vJOB_STATUS	= DSTranslateCode(DSGetJobInfo(DSJ.ME, DSJ.JOBINTERIMSTATUS))
			* The interim status of the just completed job itself
IF vJOB_STATUS = "Finished OK"

throbinson

I've used it for two digit codes. The trick was inserting a character that wouldn't appear in the field like this; INDEX('12|23|45|XY',LINK.FIELD,1). You'll get a non-zero return for 12, 23, 45, and XY codes. You can go bigger I'm sure, you just have to make sure that a field doesn't show up as a su...

throbinson

Boom! I think I originally got it from a DSGuruB post.

throbinson

And yet Index will work on more then one character. Advantage -- Index!

throbinson

hunh? I just tried it. works great. What doesn't work about it? If 1 or 2 or 3 is in LINK.FIELD the result will be non-zero.

throbinson

INDEX('123',Link.Field,1)

throbinson

I have done it with the Teradata API stage but it is definitely a case of the operation was a success but the patient died. I pre-built the SQL as a parameter based on a job that reads the system tables. This parm was passed to the Upsert job in the custom SQL.

throbinson

You mean a Primary Key. A Primary Index is how the data gets hashed across AMPS in a Teradata DBMS. They can be two very different things.

throbinson

How about a Unique Secondary Index definition in the Close Command? Why the requirement for a UPI?

throbinson

An Oracle NUMBER without precision or scale (A floating point number) is interpreted by Datastage as DECIMAL(38,10). Also any function call resulting in a numeric result. One CANNOT change this from the column grid as any metadata you define in the job will be overridden when the stage executes. Dat...

throbinson

If you're good, money is easy.

-- Eddie Felsen to the Cruiser.

throbinson

What's the Config file used in the failed run got to say? Where are the nodes pointing for resource and scratch disks? The config file used for the failed run will be in the director logs and will list the directories.

Search found 296 matches