DSXchange

ray.wurlod

DataStage is not geared to employ interactive commands. DataStage processes run as background processes (they don't have a terminal interface).

ray.wurlod

You can not rename, but you can copy then delete.

This will temporarily require double the volume of the Data Set on your resource disk(s).

ray.wurlod

WHAT "aborted job log in UNIX"? DataStage does not automatically create one of these. Perhaps your designers are writing one. In that case, it is whatever they designed that will be in that log.

ray.wurlod

What's different about the production environment? Clearly "nothing" is not the correct answer.

ray.wurlod

Here is a prototype. Every project has the EXAMPLE1 table. SELECT EVAL "IF INDEX(PRODUCT,'Pro',1) THEN PRODUCT[INDEX(PRODUCT,'Pro',1),3] ELSE ''", PRODUCT FROM EXAMPLE1; Of course, since you know exactly what you're looking for, you could hard code that. SELECT EVAL "IF INDEX(PRODUCT,...

ray.wurlod

%2000yy

ray.wurlod

Try this command in Administrator. SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME NOT LIKE '\\%'; If your jobs are listed there, the problem is either that the indexes need rebuilding, or that the metadata delivery service ("the services") are not running. To find out whether the indexes ne...

ray.wurlod

Ah. I misunderstood. As noted, take the left 19 characters, a space and the right two characters. Use a stage variable to avoid calculating the timestamp twice. svTimestamp <-- Oconv(Date(),"D/MDY[2,2,4]" : " " : Upcase(Oconv(Time(),"MTHS")) Left(svTimestamp,19) : "...

ray.wurlod

The Index() function is the one you want.

Code: Select all

(Index(InLink.TheString, "PO BOX", 1) > 0)

or you might add other variations

Code: Select all

(Index(InLink.TheString, "PO BOX", 1) > 0) Or (Index(InLink.TheString, "POBOX", 1) > 0)

ray.wurlod

Lose the "H" from the time conversion, which specifies a 12-hour clock. No "H" specifies a 24-hour clock.

Code: Select all

OCONV(DATE(),"D/MDY[2,2,4]") :" " : OCONV(TIME(),"MTS")

ray.wurlod

What the actual letters mean has never been revealed. Wherever you heard "OR" was somebody's supposition. I've also heard that "RT" indicates RT_LOGnnn (the local repository hashed file naming convention) but can't cite any reference for that. Again, I suspect my interlocutor was...

ray.wurlod

Derive ACTIVITY_STATUS as

Code: Select all

If InLink.LastActivityDate < DateFromDaysSince(-365,CurrentDate()) Then "INACTIVE" Else "ACTIVE"

ray.wurlod

Why is the activity variable contained in sharp signs? Build the expression with the expression editor. You should get something like Convert(@FM:" ", "", Fetch_NumTblNames.$CommandOutput) I believe that your reference to a non-existence stage variable is returning -3 (DSJE.BADPA...

ray.wurlod

No. I don't know Teradata.

ray.wurlod

Sentence #2 of my previous reply.

Search found 53125 matches