DSXchange

Hello,

Is there any way to export my test cases from the routine test area? I wish to test another external application with same data. It does not seem there is any way to select multiple cells and copy from that interface.

Thanks.

It is working now. I must have screwed it up first time I tested.

Thanks.

For the record, this poster did read history before starting this topic. This is why the original post was qualified with a 'without having to make a copy and compile'.

I also could not get the following to work:

DEFFUN ConvertMonth(a,b) CALLING 'DSX.CONVERT.MONTH'

Is there a way to call the example routine ConvertMonth without having to make a copy and compile.

If there is, please provide the DEFFUN statement.

Thanks.

Thanks. The status function came in handy here. I needed to distinguish status=1 and status=3.

Is there some reason for the inconsistency in the way DS handles invalid dates? For Example, a day value that exceeds the normal range for that month returns null, but if it happens to be February 29th in a non-leap year, it returns the first of the next month. This means there is no way to capture ...

I think I solved my own problem. I used the MATPARSE functionality.

DIM myArray(40,3)
valStr=<120 array values comma delimited>
MATPARSE myArray FROM valStr, ','

Could somebody please post example of how to assign multiple array elements in one statement. Something similar to C array initialization list. I can find commands for assigning all elements the same value, and building a array from file contents, but how about hard coding a static table. ie. I want...

Is it possible to define parameters in terms of other parameters? Take for example: X="Hello" Y=#X# Then if I reference #X# in a component return "Hello". Is it possible to do something like this? I am unable to get it working. Y is returning #X# rather than "Hello". Th...

Assertion: DataStage BASIC does not have an expression evaluating function. Now that I understand the requirement, I'd suggest going out to the UNIX expr command to evaluate these expressions. Beware, however, that the expression elements have to be separated by spaces, and any operator meaningful ...

Hello All, I have a column which contains a mathematical predicate expression. The possible operaters are +, -, *, /, =, >, < . For example '3 + 2 = 7 - 5' (a false expression, not a typo). There is no specified limit on the number of operands and operators in the expression. I was wondering what is...

Does anybody have examples of buildops where there is some aggregation functionality being done, or making use of column names passed as parameters?

What are my options in DataStage for computing checksums either on a particular field, or on the file as a whole?

I wish to compare checksums between generations of files to ensure that it is not the same file, and I do not wish to keep around the previous file to do this comparison.

Suppose I wished to have same functionality of Remove Duplicates stage, but also have deduped records go to a reject port. I have read many solutions in achieving this with transformer stage. I prefer to have an inteface that would have the user specify a key and options to keep first or last instan...

What is the quickest way to obtain a schema file definition given a table definition from DataStage Repository using command line interface?

Thanks.