DSXchange

You can make the target column a VarChar and assemble the string however you like.

In that case (not having version 8.1) you need to use the client-side command line dscmdexport or dsexport (search DSXchange for more information). Again there is no check-out/check-in capability, though some sites use the export file itself as "source code" in source code control systems.

Alternately do the test first (using IsValid() function) and only attempt the conversion if the validity test succeeds.

If you're on version 8.1 you use the istool command, which is part of the Information Server Manager. Currently it does not have complete version management with check-out/check-in, but this is promised in a near future release.

I'm surprised you didn't throw twos-complement versus ones-complement into that comprehensive discussion. Or Big-Endian versus Little-Endian (so that "leading" suddenly becomes problematic as a term).

So the magic word is, indeed, "backup". If you don't have one, the answer is going to be "no". If you do have one, the answer is going to depend on precisely what kind of backup. Easiest would be a DataStage export.

Nothing changes. All ODBC drivers present the same solution (essentially the ODBC API) no matter which database they actually connect to.

There is none of which I am aware. The description/syntax help for istool (just enter the command by itself) should reveal everything you need, otherwise search DSXchange. Wrapping that in a script will depend on precisely what you want to do with the file(s) produced.

You are not right.

The Generator property folder for a date data type includes Use current date as an available property to add.

Try importing the table definition specifying correct column widths (7 and 5). Field Width is a separate property, but will be stored in the table defintiion if you import using "fixed width". Then open the table definition, visit the Layout tab and select the Parallel option to get your r...

If you have the SAP PACKs you should have the documents, since they ship on the same media (or can be downloaded from the same location).

Are your dates Date data type or string? (I recall that range lookup does not work properly with dates, but that may have been fixed.) Otherwise yours is a classic case of range lookup on reference input. Choose the lookup type as Range then double click in the Key expression field to open the Range...

Something in your Windows configuration is limiting the number of child processes that a process can create (to a total of about eight, it would seem). Check with your Windows system administrator.

chulett wrote:Mmmmm... pie.

(Said in my best Homer Simpson voice)

Nah. It's Weebl!