DSXchange

parameter set is new functionality provided starting with v8x , wherein we can define a group of parameters as a "parameter set" at project level, and then can use that set in all of the jobs of concerned project. Thereby eliminating the need of defining the parameters in each job specific...

Is it confirmed that after first occurrances of "B" there would not be any occurrance of "A"? If that's the case, then you can use the Index() function in transformer to get the position of first occurrance of "B", and then use that to cut the input string into 2 column...

dsjob -run -param '$APT_CONFIG_FILE'='/opt/IBM/InformationServer/Server/Configurations/${file_name}.apt'

Thanks for the suggestion "Kris". That didn't worked though .. (
As a workaround, I am updating table by generating UPDATE statements at run-time for each target table and directly executing them from UNIX.

I have a requirement wherein I have to update the DB2 (on AS400) tables from the input dataset by passing the update statement as parameter. The input dataset schema is like - COL1, COL2, COL3, KEYCOL1, KEYCOL2, KEYCOL3 And say the target table schema is like - COLA, COLB, COLC, KEYCOLA, KEYCOLB, KE...

I have verified the solution. You could read the files using file-pattern and then reject using Column Import stage. You must get the file-names in reject from column import stage.

Hi All, I am using file pattern in sequential file to capture the data.I have a file name column to which populate the name of the file it is extracting.My problem is the reject link data is not showing the file name. How do I know which file is rejecting the data if file name is not populated in r...

I would suggest you to read DATE columns as VARCHAR (SQL Server stores date values in default format "%dd-%mm-%yyyy"), convert them in date using transformer and then load in ORACLE.

u can remove the tabs using "TR" command.

tr -d '\t' < {input file name} > {outut file name}

The logic could be implemented in a transformer stage using stage variables as explained below - Suppose the input column name is "A" storing the entire string, i.e., "Austin+Texas;Blue+Sky;air-baloon+ride;Laptop+Pad;Grass+Green;Deep+; " Stage variable: SVarIndexString Derivation...

Sorry for the copy/paste error ...
for C and D, you should use the following function -

Column for calculation = C
Minimum Value output column = C
Column for calculation = D
Minimum Value output column = D

Have you tried using the "Aggregator Stage"? You can Hash/sort in input of Aggregator Stage on field "A", and then you can specify following properties in the stage --- Grouping key = A Aggregation type = calculation Column for calculation = B Sum output column = B Column for cal...

As a test, I converted the shared container to local, and it works correctly.

We are working on DataStage V 8.0.

We have not yet contacted official support provider.

Have you find any solution to your problem?
We are also facing the same issue.