DSXchange

I have done those settings but still the 2 records are being rejected.

000255 000431 C BC R SKD 1740 OUT 1925 G/T D23A PSV 1925 CGO 1819 R MEL RTG N 390 MEL.'\n' 000125 000139 888'\n' 02000 002014 CO 888'\n' 001435 001508 O K AC CREW REPORTS LH FAIRING TO FUSELAGE RETRACTABLE'\n' Above is fixed width file except for the last record which can be variable. So have define...

I have the same problem , but am getting the error when the last field is null , when the last field has a value it works fine, but when the last field doesnt have a value then it gives me the Input Buffer Overrun Problem.. please advice.

awk '{printf "%-<your desired length>s\n",$0}' input_file_name > output_file_name Example : awk '{printf "%-203s\n",$0}' OA001.M02.TERA2 > OA001.M02.TERA3 Use the above command and make the file fixed width of your desired length then you need not worry about a few records being ...

Please check your LD_LIBRARY_PATH and make sure the library file being referenced is part of you LD_LIBRARY_PATH

Started working on the assignment..going ahead with Stored Procedures..thanks for all of your opinions guys..

Mostly it is metric calculation done on a weekly basis used as a planning tool.. so its gonna read from and write to the same database.

Hi ,

I have been given a new assignment to convert stored procedures to jobs. Do you guys really think its advisable to convert a MS SQL Procedure to a DataStage Job ?

JOB DESIGN DATA IN SEQUENTIAL FILE The output from the first Webservice transformer is a complex xml. <header> <Plusdcu> <element1/> <element2/> <element3> <element31/> <element32/> <element33/> <element3/> </Plusdcu> </header> but what I am getting in the output of the webservice transformer is <h...

I am trying to get the max sequence id in a previous stage pass it to this ODBC stage and altering the sequence to increment by that number... it works when I had code a value or pass it as job parameter..

It doesnt have a before/after sql..this is in the main sql..

Andy has given almost all the instructions to abide.. if then too it doesnt work..please go in for a complete restart ==engine , asb , websphere engine..

I have searched the whole forum but nothing helpful came up hence posting this question. We are trying to start the DataStage 8.1 on our server using uv -admin -start command but still dsrpc service is not starting. I get following messages but no error messages: Starting JobMonApp JobMonApp has be...

When I give the following user defined SQL in the ODBC Stage ...

alter sequence maximo.queryseq increment by ? .. its throwing an error ::


[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC Oracle Wire Protocol driver][Oracle]ORA-01722: invalid number
LASTQUERYID = 3881

Any ideas ??

anbu wrote:This gives a new line character

Char(10)

Thanks Anbu..