DSXchange

how can i represent blank values in datastage? i want to populate blank for some rules, i have tried "" and " " but the error is comming as attemted to "" convert to string treated as null. i have also tried @NULL.STR but it is not working how can i represent blanks th...

You have moved on from the original problem, and now getting a different problem. Again, it is likely that a required stage property (the temp directory pathname) has not been provided. ... Hi Ray, Thanks for your reply. i have given the temp file directory. could you please tell me the parameters ...

Try to search for the error message/db2 bulk loader. Every one of us who used the bulk loader for the first time had one issue or the other with it in fixing permissions, getting the directories paths properly stated, getting all the properties right. Do a search and you will get the solution to al...

DSguru2B wrote:Load immediate and load from client, both these properties need to be set to Yes.

Thanks for your reply.

i tried the same. but i am getting the following error.

Error in accessing a file or path of type "TEMP_FILE" during load or

load query. Reason code: "7"

Hi, I am loading the data of sequential file in to a table using DB2 Bulk Loader. i have given the following parameters: Load method: sequential file. Load immediate: No Load from client: No Directory for data and command files: <path of directory> Local message file name: <path of directory>msg.txt...

Hi, I am facing a problem while doing a transformation. Input column data type is decimal 18,5. Input record is 9999999999999.99999. I have just mapped the input column to output. And output column's data type is also the same. when i ran the job, i am getting the following value as output. 10000000...

Hi,

Please use Rnd(inputcolumn name) function.

Hi,

Instead of using ODBC stage use Dymanic RDBMS stage. In that stage,
go to SQL tab. you can see Generated, user defined, before, after tabs.
In that before stage, put your query to delete the records in child table.
Hope that this will help you to resolve your problem.

Hi, I am facing this problem. Scenario: a) Source db2 table on unix has 14 million records b) Target db2 table on mainframe has 40 million records c) The requirement is to delete the records in the target if they are there in the source. d) No indices etc. available on the Target. e) Enterprise stag...

Hi, I need to create sequence number per ID. For ex: Input is ID column. Output is ID and sequence number per ID. ID Sequence_Number 100 1 100 2 101 1 102 1 102 2 102 3 102 4 103 1 If the Current records ID matches with the previous records ID, i need to increase the sequence number otherwise it sho...

Hi, I am having a sequential file which is Tab delimited. The records in the file is as follows: Rec# AcNo Value1 Value2 Value3 Value4 1 100 111 112 113 114 2 200 211 212 213 214 3 300 311 312 313 314 4 400 411 412 413 414 5 500 511 512 513 514 6 600 611 612 613 614 For the 3rd record, the value of ...

How to call subroutines in ODBC stage? For example, I have a requirement. I need to extract data from a table named A and i have subroutine S which extracts data from one input file. My query would be, select * from A where bus_date=getrolldate('input file name') bus_date=one of the coulmn of table ...

Hi all, I have requirement in DataStage Server job. The transaction done by a customer for a particular month is summarized and stored in a table for last 24 months. The layout of record is like below: AC_NO PERIOD RETLQTY RETLAMT RETURNQTY RETURNAMT ATMQTY ATMAMT CADVQTY CADVAMT 100 2005-10 0 100 0...

Hi, How can I give the delimiter Tab in the Format options in Delimiter Field inthe Sequential file in Server Jobs? give me reply asap Quote: Time is money but when you don't have money time is all you can afford. --- Moved by moderator --- DS version,Job Type and OS arbitrarily set ---------------...

how to genarate surrogate key in server job?

Thnx in advance,
Selva