DSXchange

@RECORD is the entire data record as a single string, with individual fields (columns) delimited by the "field mark" character (also accessible as the @FM system variable). Within multi-valued fields, individual values are delimited by "value marks" (@VM) and within multi-subvalu...

You are correct. It doesn't. That's not the way UniVerse - and therefore the DataStage Engine which is based on UniVerse - works. The columns displayed by the asterisk are defined in the file dictionary using a phrase entry called @SELECT or, if that is not present, by a phrase entry called @ or, if...

uvsh - or its synonym dssh - is for executing commands in the DataStage shell. These include SQL statements, but include other statement types as well. When modules can not be loaded it usually means that your shared library search path (LD_LIBRARY_PATH environment variable) is not correctly set or...

Given that the Data Set already exists, it must be accessed using a compatible configuration file (one that refers to the 20 nodes with which it was created). The orchadmin command has options to bypass this requirement but the Data Set stage does not (except in a grid environment in version 8.1) as...

Because there are "system table" entries that refer to objects by pathname. Unless the new pathnames are identical to the old, there will be grief.

Any solutions please??? This is offensive. You waited less than two hours. These were the "wee small hours" in my time zone and I was asleep. DSXchange is an all-volunteer site, whose members post when they can, if they have something to say. If you want rapid response, sign up with your ...

1) Not necessary, but wise. You get the same benefits as on MPP. 2) Your result is an artifact of using a small data volume. For large data volumes, you will get a quicker completion time using two nodes versus using one. 3) Partitioning works in exactly the same way on an SMP system with just two e...

Apart from doing it properly (not with an operating system copy command)?

Not really.

Does bin/dssh work instead of bin/uv ?

You CAN omit fields as you read. Use the Drop on Input property in the extended column definition.

Use Record Delimiter String = DOS Format, not Record Delimiter = UNIX newline (because your server is on Windows).

DataStage IS able to do so, but may you have to tune the maximum number of columns and, probably, maximum buffer size for the DSN. You do this in the uvodbc.config file using MAXFETCHCOLS and MAXFETCHBUFF parameters. Of course, the maximum size of a VarChar column is limited by the ODBC driver itsel...

What do you get as the data type when you import the table definition from Oracle?

Wrap it in Code tags; use Preview and edit it until it's right.

Check "add warnings for activities that do not complete successfully" and/or add Nested Condition activities to test output or exit status from the commands, plus routine activities invoking UtilityWarningToLog().

Wrap it in Code tags; use Preview and edit it until it's right.

Check "add warnings for activities that do not complete successfully" and/or add Nested Condition activities to test output or exit status from the commands, plus routine activities invoking UtilityWarningToLog().