DSXchange

For those for whom it is unclear, "splat" means asterisk. The verb "goofs up" in this context means "prevents proper display of".

I just wonder whether you could simply use SQL Server utilities to move all the tables to a different server. All the information therein is what the services access; about the only possible reconfiguration might be telling the WAS where the Information Server database is.

Don't be "damn sure". Check. If there were no "R" in your data you would not get this error message.

Job sequences are partially compiled on the client machine. This error possibly relates to your not having write permissions in the relevant folder on the client machine.

Depending on how you build them, job sequences do maintain the Dependencies area.

I suspect you're thinking of the link variables available in server jobs.

You follow the installation instructions that came with the driver. To configure a DSN, you need to do two things; the first is to put an appropriate entry into the .odbc.ini file in the DataStage Engine directory (which is where all DSNs visible to DataStage are recorded). The other is to record th...

Can you please purchase a premium membership? Premium membership is one of the ways that the hosting and bandwidth charges incurred by DSXchange are defrayed. Membership is not expensive, at less than 30c per day. I do not propose to set a precedent of undermining that funding mechanism. Therefore I...

Have you diligently maintained the information on the Dependencies tab in your job properties and routines? If you have (and only if you have) the following routine will extract that information. FUNCTION JobDependencies(JobName,Indent) * Modification History (most recent first) * Da...

First you also need an ODBC driver for MS Access installed on your (UNIX) DataStage server machine. Do you have that?

The only thing I can suggest is that the Copy stage is kept because its output does not connect to a virtual Data Set. Indeed, the operator associated with the Data Set stage is copy which may mean that "your" Copy stage was eliminated, but there is a copy operator to transfer data to the Data Set. ...

Welcome aboard.

While what you want to do is easy, your requirement is incomplete. For example, what do you want to DO with this count?

What is the input value (LT_data.data), what is the expected output value, and what is the actual output value? What is the exact function call that you used? And, finally, what do you wish to achieve (in English, not in code)? Please review, in on-line help or in the DataStage BASIC manual, the ord...

source ---> Transformer ---> Sequential File In the Transformer stage create a single output VarChar as Id : svLF : name : svLF : sal Stage variable svLF is initialized to Char(10) and is not assigned a value for each row processed. The sequential file will have three rows for each row that you wri...

Don't know. Can we see the generated OSH? I'm particularly interested in the record schemas - obsfuscate the column names if need be, but preserve the 1-1 relationship between real names and obfuscated names.