DSXchange

ray.wurlod

Please execute this command on your system, because the data type should be OK.

LIST DICT.DICT 'LOC'

If the format ends in 'L' or 'T' then the quoted value is satisfactory. If you can't get it to work, use FUNC rather than LOC everywhere.

ray.wurlod

These are fields in the NLS locale definition.

Code: Select all

LOGTO UV
LIST.DICT NLS.LC.TIME
SELECT * FROM NLS.LC.TIME WHERE CAT_ID = 'US-ENGLISH';

I get D2/MDY as the default date format for US-ENGLISH. Has someone ignorant been playing at your site?

ray.wurlod

I must've missed this when you originally posted it. I have not seen the behaviour. But it suggests that there remain entries in the XMETA database (unified metadata repository for Information Server) that refer to these projects. How did you attempt to delete the projects in the first place, and we...

ray.wurlod

Convert to string, check the AM/PM designator and change the hour piece if necessary. Lose the AM/PM designator and convert back to timestamp.

Or, probably easier, specify an explict TO_CHAR function in your Oracle SELECT statement that has HH24 in it.

Code: Select all

TO_CHAR(mytimestamp,'YYYY-MM-DD HH24:MI:SS')

ray.wurlod

The timestamp field must be nullable on the outer input link(s) and on the output link.

ray.wurlod

Different INSERT statements have different columns into which they insert. And you do have to execute the COMPILE.DICT statement as well as the INSERT statements. Note that this is not SQL, so does not take a terminating semi-colon. And all the commands are case-sensitive. You can copy/paste them in...

ray.wurlod

Who is doing the telling, and do they have any DataStage knowledge or experience?

What do "they" want you to achieve using session tables? How were you planning to do it?

Resist stupid requirements!!!

ray.wurlod

If there are no gaps, then my MIN and MAX solution is good. And faster. Especially if these columns are indexed with B-tree indexes.

ray.wurlod

There's a section at the end of Chapter 2 of the Parallel Job Developer's Guide that lists the restrictions on using server shared containers in parallel jobs. I can't check right now, but I seem to recall that one of them is that the server shared container must have an input and an output.

ray.wurlod

I would recommend writing a job sequence that uses a Wait For File activity, and starts a copy of itself with a different invocation ID before finishing. Provide an alternate mechanism for notifying it to shut down gracefully.

ray.wurlod

No sympathy. Dennis makes me present webinars at 6AM local time (which means being on-line by 5:30AM).

ray.wurlod

That's because there's no such thing.

ray.wurlod

or DSINCLUDE/JOBCONTROL.H

Look for the constants whose names begin "DSJS."

ray.wurlod

Change your Control-M script to be more gracious about status 2 (finished with warnings).

ray.wurlod

Note that if what you want is a list of the activities actually executed, rather than the activities in the job sequence design, a radically different approach is needed. Since you have marked the thread as Resolved, I will assume that this is not what you wanted in this case.

Search found 53125 matches