DSXchange

Maybe you could test the rightmost character with IsValid() to determine whether it is a valid string. A character that is valid as a ustring but not as a string might fall into your "non-ASCII" class.

There is no magic wand. If you've customized the CRM, you have to customize the extraction portion of your ETL to match.

As far as I am aware there is no such thing as an "API stage" either.

Forget the function. The same number is available in the system variable @INROWNUM.

Your job design needs three lookups, not one.

There are also limits on row size and column count for ODBC that are set in the uvodbc.config file. Defaults are 8KB and 400 respectively; they are set using MAXFETCHBUFF and MAXFETCHCOLS.
Are you using ODBC as the connection type in your Dynamic RDBMS stage?

Not true. DataStage job will generate processes. You can run as many processes as the resources (CPU, memory, I/O bandwidth, etc.) will support. If you choose to use some of your resources running parallel (simultaneous) instances of things, that's your choice, even with only one CPU. If each proces...

jeyavel wrote:Can we access the job(version 7.1) from Datastage client 7.5.1.A?.

No.

This would be the simplest of DataStage jobs.
You do not need PL/SQL at all.

My guess would be that "U" is a name and "you" is a pronoun and that you use each appropriately.

The configuration file specified by APT_CONFIG_FILE is for parallel jobs. You are trying to specify it for a server job. Anything you create with the Configurations editor in Manager will make no sense whatsoever in a server job. For what purpose do you want to use a "configuration file"? Might I su...

Use a hex editor on your source data. Or you only trying to create a target file with 253 as the delimiter?

Please advise whether you have DataStage NLS enabled and, if so, what map is being specified for the Sequential File stage.

An empty hashed file (one with zero records) will have a header in each of DATA.30 and OVER.30. The header is 2KB in size unless GROUP.SIZE is set to 2, in which case the header is 4KB in size. You hashed file is therefore using only one buffer in OVER.30. This might be an overflowed group, it might...

You can use a UV stage for this. You need to "lie" that the keys are fromValue and to_Value, and to use user-defined SQL to incorporate your condition. SELECT id,fromValue,toValue,Description FROM hashedfile WHERE ? >= fromValue and ? <= toValue; It will also be necessary that a VOC entry exists for...

DataStage NLS replies upon a byte order mark being present in the file header. This tells DataStage whether the byte order of the machine is big-endian or little-endian. Byte order is critically important when there can be more than one byte per character. For example, in a hashed file the first two...

Is the base number hexadecimal and you wish to add, or is it the leading digits to which you want to append a four digit sequence number? Should the sequence number be hexadecimal or decimal?