DSXchange

Have you set the line termination to Unix (LF) in the sequential file stage -----Original Message----- From: ccezon@bancozaragozano.es [mailto:ccezon@bancozaragozano.es] Sent: 28 January 2003 07:36 To: datastage-users@oliver.com Subject: Sequential file Hello, I have a problem: I have a sequential f...

Hello Denzil I took a test job called Job1 and successfully cleared its log from command line by doing the following: > list DS_JOBS = Job1 { This returned No... 369 } > CLEAR-FILE DATA RT_LOG369 The clear-file data command works a treat. Feel free to destroy your system from the command line, best ...

Hello, I have a problem: I have a sequential file fixed with columns / spaces between columns = 1. For example: lenght display containts terminators inclomplete column field1 3 3 No replace field2 2 2 No replace field3 2 2 No replace field4 2 2 No replace field5 2 2 No replace The Unix file is: 11 2...

did you try if isnull(row) then "" or if isnull () then @NULL etc type thing? amcguinness@qbe.com.au wrote: >Hi > >I have a situation where source data from an ODBC stage that legitimately >contains some empty strings. These strings are treated as NULL values by the >RedBrick load stage. > >The sour...

Ray and Vincent Thanks for your input, as both recommendations helped. There is no doubt DS is interpreting the "" as an empty string, as IsNull does not pick up anything. It seems when RB gets "" it treats it as null. The solution is to test for "" in the transform, and replace it with " ". RB then...

If you are bulk loading into to Redbrick you can tell DataStage not to delete the text file. You can go look at it afterwards and see if there is a null in it. DataStage also creates the tmu file and the discard file. All bad records will go into the dsc file. Kim Duke DsWebMon - Control DataStage f...

Without knowing much about Redbrick I can take a shot in the dark, is your sequential file stage replacing the empty strings with a single space? Usually to place an empty string into a NOT NULL database string field you need to use a single space character. In your transformer you could replace NUL...

Im pretty sure theres something you can do in the load script for rb_tmu here but Im without my Red Brick Warehouse resources this week. Perhaps you could check this out in the meantime? Also, how sure are you that DataStage is generating the NULL values? Can you put in an extra output link through ...

Hi I have a situation where source data from an ODBC stage that legitimately contains some empty strings. These strings are treated as NULL values by the RedBrick load stage. The source data passes through a transform, which then feeds the RedBrick stage. RedBrick rejects records that are empty stri...

Peter, I think you need to change your approach slightly. Rather than job control code in the job that is being run to look up your hash file, move that logic back to the job that runs the job. Build a function whose purpose is to run jobs. Amongst other things (including some parameter handling, ch...

Hi Doris When you are defining your columns, if you scroll over to the right, there you will find a column (Incomplete Column), with a drop down list of all the options that are available for the type of error you are experiencing. You can either abort the run (error option), replace the column with...

Hi Doris, The problem is that line 5 there isnt an expected field. You can check it opening your file by notepad (on NT) or by vi (on UNIX). Remember that what is important in the definition of a fixed width file structure in DS Designer, is the "Display" field in column Tab. If you check the record...

Make sure the definition of the CUR_MOD_BUDGETED_AMT column in the Sequential file stage has Contains Terminators set to No. Note you have to scoot over to the right to see these column attributes. -craig Kasia Lewicka 01/27/2003 07:02 AM Please respond to datastage-users To: cc: Subject: Re: column...

Hello group,
While trying to read a fixed length sequential file I receive an error
...read_fixedwidth() - row 5, column tdi_cont, required column missing.
Any suggestions on why and how to work around this would be appreciated.

Regards,
Doris

Perhaps there is just a carriage return symbol in the last line of your flat file. DataStage try to read it as a data line, but it contains just one character and not all those defined in your stage. How many rows in your flat file? Kasia At 18:01 24/01/2003, you wrote: >Hi, > >Running a job which s...