DSXchange

ray.wurlod

Open command to drop indexes, Close command to re-create indexes. Open command in either stage, Close command in target stage: I'd put them both in the target stage.

ray.wurlod

Probably better to use the Open and Close commands in the ODBC Enterprise stage (or SQL Server Enterprise stage, if that's what you're using).

ray.wurlod

What about holidays?

This is the kind of situation where you need a time dimension table, which flags the day type. Your result is then a simple query of the form

Code: Select all

SELECT COUNT(*) FROM TimeDim WHERE THE_DATE BETWEEN :1 AND :2 AND DAY_TYPE = 'B';  -- 'B' = business day

ray.wurlod

Actually, the answer is that there's no Oracle enterprise stage in server jobs. You marked the job type as Server.

ray.wurlod

There are two errors here. One is that DSHOME or APT_RESPATH environment variables are not set, so that DataStage can not retrieve the text associated with the error. This is easily fixed. The second, for now, is "??". Once the first has been fixed there may be some useful information ther...

ray.wurlod

There is an entire manual on DB2 connectivity. Have you read it?

Are you using DB2 Connect on the DataStage server (which is the DB2 client)? This is the usual method for accessing DB2 tables on different platforms.

You still need to bind, though.

ray.wurlod

Yes, provided you're using the current version UniODBC driver.

ray.wurlod

Convert to or from what?

ray.wurlod

That's not how Data Sets work. So, no.

ray.wurlod

In UniVerse the conversion IS in metadata, it's stored in the file dictionary of a hashed file. Since you are dealing with a byte stream, there's no corresponding metadata-based mechanism.

Can you give examples of all formats so that we don't have to guess a "best" solution?

ray.wurlod

The best answer to Q10 is "more".

ray.wurlod

...i got it.. but u invoked another query in my mind. In either way of this migration process, crontab entry is going to be affected. Isn't it? Or do u mean it would get affected only with the "OVERWRITE" process, u mentioned. I don't recall that U posted on this thread! Please strive for...

ray.wurlod

The first error is
ORA-12154: TNS:could not resolve the connect identifier specified

Resolve this first. If you can't connect to Oracle there's no much point proceeding with diagnosing the other messages, which may result directly from the first.

ray.wurlod

EVAL expressions take BASIC functions, not SQL functions. There is no SUBSTRING function in BASIC (you can use SUBSTRINGS or the square bracket notation).

Code: Select all

SELECT EVAL "IF MSG.ARGS = '' THEN MSG.TEXT[5,LEN(MSG.TEXT)-13)] ELSE MSG.ARGS" FROM RT_LOG21 WHERE TYPE=5;

ray.wurlod

No, it was introduced in version 8.1.

Search found 53125 matches