DSXchange

Your original solution was great, you just needed to add an additional column at the beginning of each output file. The derivation of that column is @INROWUM. This means that each output file would have a column that is the original line number in the source file. Carry that value to the end of your...

Test plans are part of software development. This website is devoted to implementing IBM's data integration products. There are no components that deal with automating testing, such as test data generators and test case generators. You're talking about making your own standards for testing. When it ...

On the DS Server, can you connect using SQLPlus? Was the Oracle client installed as Administrator and enabled for all users?

Yes, but only by using a "hack" update into the internal repository to mark the routine as read only or exporting the routine and updating the metadata in the .dsx file to mark the routine as read only. There's no checkbox or other supported method for doing what you ask in the Manager/Designer clie...

The logs degrade performance only when the job has to put a message into its log file. Since the log file is actually a dynamic hash file, an extremely large hash file may take longer to add a row, especially if the file just happens to need to dynamically expand at that point in time. If the job is...

The Search facility is your friend.

shyamsrp wrote:Iam throwing out the row which contains the DATE, as that is header data

Don't throw it out, parse it and update a stage variable. Use the stage variable in the derivation of the target column.

Use a stage variable to hold the value from the row that contains the date.

Double-check your datatypes. Are you sure this is the actual row of data? Sometimes NULLs have issues.

Thanks for backing me up Ray.

Ken, Kenneth, Mr. Bland, hey mister, buddy, yo, but for heavens sake, never Kenny.

Use three stage variables: GroupKeyChanged = CurrentGroupKey <> inlink.groupkeycolumn CurrentGroupInternalNumber = If GroupKeyChanged Then 1 Else CurrentGroupInternalNumber + 1 CurrentGroupKey = inlink.groupkeycolumn In the output link for the group key, use a constraint of just stage variable Group...

A stage variable to track changes in the first column should do the trick. The only difficulty you will have is the extra output row when the change occurs. You'll need to output a row with the group value, then output the remaining data for the first row in that group as a second output row. Then, ...

The S99ds.rc script that starts/stops the services actually READS the dsenv file and write a temporary one used later on in the script. You may want to look thru this script and see if you can identify where the problem is occurring. You might have a syntax error or a permissions error somewhere tha...

What's with the "$" notation? Job parameters are referenced like this--> #yourparameter#

ORAOCI or ODBC, whichever you choose. The bulk loader is the ORABULK stage.