DSXchange

Can you please sketch out your job design? Can you use Copy or inline Peek stages and capture the output of each Aggregator for diagnostic purposes?

The ODBC protocol provides for identifier names that begin with an alphabetic character and contain only alphabetic, numeric or underscore characters and are not more than 18 characters long. Some ODBC drivers allow longer names, but none (of which I am aware) allows you to violate the other identif...

Create a routine or command to read the log entry in question and write it to your file.

Welcome aboard. A simple answer is that it works with data whose format is specified in a COBOL FD. There is a chapter in the manual describing more detail - please read that, as I don't want to have to regurgitate it here.

How about you Search DSXchange? This question has been asked and answered more than once in the past. The Pivot stage does not perform a vertical pivot, but there are other techniques for doing so.

Read the file as comma delimited.

Write the file as fixed width format. The display width will be the width of each column in the written file.

Put a Transformer stage between the two Sequential File stages so that you can have links with different format properties.

If you know that the DOS-style terminators will be there then you can specify DOS-style (rather than UNIX-style) on the Stage properties tab of the Sequential File stage that reads the file. Otherwise you can remove the Ctrl-M characters either before they get to DataStage or within the job.

Control Panel

Regional and Language Options (or something similar).

Get a book such as "UNIX for Dummies" or any elementary guide to learning UNIX.

Is it an integer or a date/timestamp? You only get format masks of this kind when dealing with dates or timestamps.

DataStage BASIC resolves the "equals" operator as If Num(A) And Num(B) Then ((B-A) = 0) Else (A = B) That is, it performs a numeric comparison if both operands are numeric. You can force a string comparison using a Compare() function or by concatenating someth...

OK, I now have the dates. Arriving in Jo'burg November 13th, departing November 17th. Have not had accommodation confirmed yet, but am happy to meet socially sometime in that period. Keep in mind that I'll not have transport so it will be easier if you can come to where I am (which I'll let you know).

Have discussed this before - a Search would reveal all. There's no export - you just move the files - message handlers are stored outside the Repository database.