DSXchange

Yes it's do-able - generate each character separately and concatenate.

You need SELECT access to a number of Oracle system tables (fully documented in the Connectivity Guide for Oracle), to which DataStage refers to determine precisely in what manner the table is partitioned. You will also need to nominate a partition table property in the Oracle stage. Oracle hash par...

Lose the If Then 1 Else 0 - the test expression itself will generate 1 or 0 in any case. Don't evaluate the TrimLeadingTrailing() function twice - pre-load it into a separate stage variable. sv1 <-- TrimLeadingTrailing(LkInto_Trns_Validation.STKRM_PULL_Q sv2 <-- sv1 > "" And IsValid("...

Planning, Installation and Configuration Guide version 8.7 page 22 Figure 14 - Topology with Two Engine Tiers

For "two" read any reasonable number of Engine tiers.

This particular slide in is purely DSXchange-related. Get Your Forum Today Design By Vjacheslav Trushkin Registered Users PhpBB Forum They all link back to this very thread!!! And there's a search tool that I'm really reluctant to try. There's a cancel X which makes it go away, but it's back again a...

You're not using ProgramID in your Job design, although it is mentioned in the schema file. You must at least read this field, even though you discard it.

That's the way it's intended to work. The last two sites I've installed have five and two engines respectively. You install selecting Engine tier only, and are then asked for the location (and other information) for the Services tier.

Char(30) will ALWAYS have 30 characters.

Trim() will trim them OK, but the data type will cause the value immediately to be padded with APT_STRING_PADCHAR characters to length.

Find the correct header file and specify its correct pathname in the #include declaration.

Or even search DSXchange. I have answered this question fully in the past.

Show us the SQL query that you are using.

A Join condition must be specified either in the FROM clause or in the WHERE clause (SQL 101).

Use the Monitor in Director. Right click in the background and select Enable Instances. Then expand the tree to see individual nodes for each parallel stage (indicated by "x2", etc.)

None of which I'm aware.
Any chance of using shorter column names to get under the 128KB limit?

Is is just me, or is anyone else getting slide-ins at the bottom of the DSXchange screen (flogging PhpBB forum, design by Vjacheslav Trushkin, etc) and occasional slide-in advertisements on the right-hand side? I'll try using a different browser (currently using IE9). Does anyone know how to disable...

AD is used to authenticate username/password and to return a list of AD groups to which the user belongs. IIS roles (suite roles and suite component roles) are assigned to AD users/groups. AD users are mapped on to one or more operating system users for access to file system on the DataStage engine....