DSXchange

Hi dssiddu

treat urgent..

If you don't know you better know this now. Any message which has URGENT is this DSXchange forum is treated as NOT URGENT. Moreover many won't even reply to this message even if they knew the answer.

Chang

if Increment <> 0 then

Where do you assign Increment variable. I can't see this variable assigned.

Thanks

Ratan

the input field is a string '12-23-2005' can we convert it into timestamp directly

Your string only has date part and not time part. What you need to do is concat date and time part together and then convert it into timestamp. If you don't have time part then have default values

Thanks

Chang There is no restriction in calling routines concurrently. I don't think that is the problem in your case. Go back to your routine and do full test on the routine to see whether it is working correct or not. You might need to give all different type of value which you receive from source. Trace...

Ratan

Look the format of the string in the source and check whether you are using the same format to check whether it is valid or not?. How are verifying whether the string is valid date or not?... Give some examples and your conversion logic we might be able to help you

Thanks

I absolutely agree with Ken. ODBC works better with these sorts. I do lots of these creating ODBC job to access SQL Server.

Thanks

Shailendra Loop stage can be used inside Sequencer jobs. What you need to do is to get the list of file names and supply this list to loop start stage with some delimiter between each files. And you can have your job to execute inside your loop. Read manual for more documentaion about how to use loo...

Rekha

Welcome to DSXchange.

You could post a new topic and have threads associated to that. If your question is not related to the existing one then post a new topic. Please don't hijack threads.

Thanks

Reddy As Ray said "Write your Own" its easy. Create a job in datastage itself to read a sequential file and in constraint have @INROWNUM =1 to one link. This will create the first record in the output file. Have another link directed to Aggregator and use the LAST option to write the last ...

Reddy

Use Routine "DataTypePicS9" as Chandru said and on top of that Divide the result by 100 to get the right decimal place for your result.

eg.

DataTypePicS9(000000200{)/100 = 20.00

Thanks

Sumeet

first investigate why you got this unique constraint error now. Check the source data and see whether any duplicates are coming. Check your job to see whether you have logic to eliminate duplicate records.

Thanks

Hi dj In your ODBC stage you have three option in General tab for "Select using" You would normally use Generated query or User-defined SQL query to do a select from database table. If you use Generated query you have to make sure that the column you type in your Column tab matches the Col...

Sam

The answer is 'Yes'.

You can have header and trailer records in your sequential file. You may have to filter header and trailer records during the process if you don't want these to be processed inside your job

Guys

Had a quick look in the Parallel Developer Guide Manual and found that not all options for Sequential stage is described inside the manual. It seems that we need to browse the real object to see all the options available for a stage.

Craig

I don't think that there is an option to skip first N rows in PX Sequential Stage. I do remember that there is an option to Read First N Rows in PX Sequential stage...