DSXchange

ray.wurlod

Report the bug.

There are too many stage types coming out that can't handle large things, including the Folder stage. D'oh!

ray.wurlod

If Ascential wrote this, they almost certainly regard it as their intellectual property. You may have to ask them to provide it, rather than Gazelle, who would be bound by a licensing agreement not to reveal details.

ray.wurlod

Certainly these are familiar-looking dictionary items. But, if you're always going to constrain on OLETYPE, why not just opt for D-types? For instance, here's how I work with parameters: >SELECT FIELD,TYPE,LOC,NAME,FORMAT,SM,ASSOC FROM DICT DS_JOBOBJECTS WHERE FIELD LIKE 'PARAM%' ORDER BY "TYPE...

ray.wurlod

It may help to delete the hashed file completely and then to re-create it. The aborted process may still be holding locks. Possibly the quickest "fix" is to recycle the DataStage services (shut down and re-start). Obviously no jobs can be running when you do this, but if you can't start any, that's ...

ray.wurlod

However, this syntax is valid:

Code: Select all

Ans = If Club = 'c' THEN COUNTRY_CDE = '2' else '0'

Some people prefer to use parentheses to indicate that a conditional expression, rather than a conditional statement, has been used.

Code: Select all

Ans = (If Club = 'c' THEN COUNTRY_CDE = '2' else '0')

ray.wurlod

7.5, unfortunately for those of us currently on 7.1

ray.wurlod

Only if both arguments are numeric.
Conceptually:

Code: Select all

If Num(Arg1) And Num(Arg2)
Then
   Result = Compare(Arg1, Arg2, "R")
End
Else
   Result = Compare(Arg1, Arg2, "L")
End

ray.wurlod

The limit is initially imposed by the physical size limit on the job log (2GB by default). More instances = more log entries. It's also affected by how many events are logged by each instance. One could, of course, convert the log file to 64-bit addressing. Then the limit is probably constrained by ...

ray.wurlod

Is that actually documented anywhere?

ray.wurlod

Some shells only allow $0 through $9; to get at more you need to employ the shift command within the shell script.

ray.wurlod

Yes I do. No they haven't. Stay tuned for announcements.

ray.wurlod

umask 00 allows everyone who has access to the machine to read and write. Everyone. If that's what you want, then OK.

umask 002 means that only members of the group (as well as the original creator/owner) have write permission; to others the objects are read-only.

ray.wurlod

Rajiv's response relies on the fact that in server jobs the internal format is an integer. The day of week can be derived using Mod(intdate, 7). 0 is Sunday (as it happens) and 6 Saturday. Thus 5 is Friday. The rest is purely arithmetic.

ray.wurlod

Use a larger data type, for example Decimal(38,0).

ray.wurlod

I wonder if the subject could be changed at the same time?

Search found 53125 matches