DSXchange

Hi, In Execute Command Activity please set the following: Command : cat Parameters: <path>/<filename> <path> - the location where your file is stored. <filename> - name of the file In the trigger of the Execute command activity - For Current Account , select expression type as custom and in expressi...

Hi,
In the query check for nullability should also be there
The query should be like -

CASE when x IS NULL......or CASE when x IS NOT NULL....

In the scenario you have quoted , put job paramater name simply in the derivation field of the column in the transformer.Dont put any '#' or any quote.

For eg. If your job parameter is Test....Then your derivation filed in the transformer for that column should be Test.

In the scenario you have quoted , put job paramater name simply in the derivation field of the column in the transformer.Dont put any '#' or any quote.

For eg. If your job parameter is Test....Then your derivation filed in the transformer for that column should be Test.

Hi! Please inform which in stage you intend to parameterise column. For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column. Or you can modify SQL to incl...

Hi! Please inform which in stage you intend to parameterise column. For eg if you are usind a db2 database stage DB2/UDB API then you simply need to put '#<Job Parameter>#' in Output --> Column --> Derivation and it would fetch the value of job parameter in that column. Or you can modify SQL to incl...

Hi Ray,
Please let me know if there is any reading material available on such commands.


Thanks in advance.

Hi Ray,
Please let me know if there is any reading material available on such commands.


Thanks in advance.

Hi Chulett, Thanks for the informative link. I have a query after going through this FAQ: If eah project is a schema residing on Universe Database then how come DSParams is a file which can be read , copied etc. Besides is there any way to query this repository for our needs as in if I want to query...

Hi all,
I have been using data stage tool for quite some time now.But am still not clear about its architecture.It would be great if any one suggest some books or links which might be useful.

thanks in advance.

Hi,
If the column is non nullable then in case of lookup failure , the returned value is 0 or empty string depending upon the datatype of the column.

Hi, For loading large volume of records from a sequential file to a DB2 database table,I noticed that the speed inreased significantly(it almost doubled) if I checked the "Allow Multiple Instance" chek box. I just want to know if this would inrease overhead in some way or would it have any...

Hi everyone, I have a similar problem. The database we are using is DB2. In my job I read data from a table using DB2 API stage and write it in a sequential file. Now in the table I have a field with char(30).When I insert a record with empty string in this column and after doing a ftp; open the seq...

Thanks a lot everyone!

Hi Sam,
Did you try reading the output as 'varchar'.I mean,did you try defining the column as 'varchar' in the output metadat of lookup itself?