DSXchange

ray.wurlod

Or obstetricians.

ray.wurlod

Don't be lazy here, please. It's irksome.

ray.wurlod

Final delimiter is a delimter that appears between the final field and the record delimiter. Occasionally you get data like that (hopefully never - it's a bad practice!). For example: 123,"John Smith",4512; 456,"Mary Jones",4669; 789,"Arthur Dent",4711; In the above exa...

ray.wurlod

Don't really know. Have your DB2 DBA trace the DML statement that is actually being received from the client (DataStage, that is).

ray.wurlod

And maybe you can't. Version 8 must have the default itag so, if your version 7 server is using the default itag, you will need to reinstall that first with a non-default itag.

ray.wurlod

A UniVerse table is a UniVerse file plus system table entries.

Code: Select all

SELECT * FROM UV_USERS WHERE DBAAUTH = 'YES';

Is your colleague a DBA? You can view the privileges through the command

Code: Select all

LIST.SICA ParamValue

ray.wurlod

NVarChar is supported. NVarChar(max) - aka TEXT - probably isn't. Try using a large bounded NVarChar.

ray.wurlod

Sequencers don't (can't) abort.

Sequences can.

ray.wurlod

We don't do "urgent" or "asap". DSXchange is an all-volunteer site whose members post when and if they can. We find "urgent" or "asap" requests/demands to be offensive. Nor was your requirement clearly stated. Do you want to calculate the date one year ago, d...

ray.wurlod

change APT_AUTO_TRANSPORT_BLOCK_SIZE to false and try to run the job Why do you give this advice? Transport blocks only apply to fixed-width records, and is given in bytes. In most cases it's calculated using a formula that involves APT_MIN_TRANSPORT_BLOCK_SIZE, APT_MAX_TRANSPORT_BLOCK_SIZE as well...

ray.wurlod

There is a DVD available from DSXchange Learning Center that gives good examples of how to use the Loop activities. It's the one on DataStage job sequences.

ray.wurlod

You don't need an Aggregator stage, because you need the moving average re-calculated every row. I should have mentioned that the stage variables should be initialized to 0 (though this should be obvious).

ray.wurlod

It is NOT an error. It is a report that the hashed file used by these routines is being created. If you don't like it modify the routines to hush the output of the CREATE.FILE statement.

ray.wurlod

For example DateOfBirth and HireDate should both not be greater than current date.

ray.wurlod

Is your ASB Agent started?

Search found 53125 matches