DSXchange

ray.wurlod

Welcome aboard! :D Glad you've gotten a solution quickly. Recommend the site to your (DataStage) friends!

ray.wurlod

Get the timestamp of the most recent event in the job log file.

Event = DSGetNewestLogId(hJob, DSJ.LOGANY)
Entry = DSGetLogEntry(hJob, Event)
TimeStamp = Field(Entry, "\", 1, 1)

ray.wurlod

When do you pick up the job's exit status? Straight after DSWaitForJob? Grab the system time then.

Code: Select all

FinishTimeStamp = Oconv(Date(),"D-YMD[4,2,2]") : " " : Oconv(Time(),"MTS:")

ray.wurlod

kduke wrote:Ray,
Wouldn't this be easier.

Will have to run both through EXPLAIN when I get some time.

ray.wurlod

In the Administrator client's command window.

At the TCL prompt via a telnet session.

Via ExecTCL (before/after subroutine).

By calling DSExecute with a shell argument of "UV".

Enclosed in double quotes following a uv command at the server's operating system shell.

... and more.

ray.wurlod

... and reported in the job log, should you require proof!

ray.wurlod

Today I needed to determine which jobs in a project loaded hashed files. Here is a query to do just that. The query uses publicly-documented column names from the DS_JOBOBJECTS table, so is totally legal (not a "hack"). SELECT NAME FMT '40L', OBJIDNO FMT '6R' COL.HDG 'Job No' FROM DS_JOBOBJECTS WHER...

ray.wurlod

You could have used print with $3 and $4 in awk, thereby only needing one output file. But, heck, you've got DataStage.

ray.wurlod

I recently attended a user group meeting offered by Ascential and this topic came up. Ascential currently does not offer any certification for there products but they are planning to in the near future. There is suppose to be three levels. The first is certification in a single product like datasta...

ray.wurlod

What is the value of ALLOWNFS in your uvconfig file? Originally DataStage did not automatically allow use of mapped network drives, because this was the default behaviour in UniVerse (for reasons unconnected with DataStage). Later versions of DataStage (certainly 5.2 and later) DataStage's default w...

ray.wurlod

There's an easy DataStage job solution. Read the file and write another, with four output columns. Field001 and Field002 are directly derived from input. Field003 is derived as If Len(inlink.Field003) = 10 Then inlink.Field003 Else inlink.Field004 and Field004 is derived as If Len(inlink...

ray.wurlod

TRIM("") yields "", which doesn't help the original problem. The OP needs to determine how the "" values came to be in the hashed file's key columns in the first place. It is entirely legal for them to be there (since "" is a known value, unlike NULL), but is clearly causing a problem. What are the ...

ray.wurlod

It's a fairly common problem. The inactivty timeout for client connections is set in the Administrator client. On the General tab there is a frame for Inactivity Timeout in which you can set the number of seconds, or check the "do not timeout" check box. The connection with the server drops if it is...

ray.wurlod

Arguably, though, "end" is not an SQL statement but rather a metasyntactic variable marking the end of a block of SQL statements.

ray.wurlod

We run 5.2 and 7.0 clients on the same PC, and use the unsupported utility ClientSwitcher to switch between them.
Are you trying to open a connection to a 7.0 server from a 5.2 Manager? (Use Help About to determine the client version.)

DSXchange

Search found 53125 matches

Which Jobs Load Hashed Files?