DSXchange

DSguru2B wrote:Or Just ask the DBA to increase the length if its legitimate data.

Yup, there is always the danger that your are 'hiding' bad data by taking my approach. Deadlines often limit investigation time into why data isn't what you expected, but the 'why' question should be asked!

Rob

Hi, I am New so Pls. give me more Info in Using Stage Variables,How to store SNO and compare with the new one Thanks a lot 3 Stage variables: ThisRowValue => S.NO CompareToLastValue => If ThisRowValue = LastRowValue then 1 else 0 LastRowValue => ThisRowValue Since the stage variables get evaluated ...

Hi kollurianu, I'm not working on Oracle at the moment, but I do recall that the OCI (Oracle) will try to convert, then if it's still not happy, it will reject. This did seem to happen on strings that were too big for the target column. Oracle didn't seem to be happy with it's own truncate. I would ...

Are you able to look at the file in a text editor that will allow you to look at the EOR characters? If so, determine whether the record ends with just x0A (UNIX) or x0D0A (DOS). If it is the latter, your FTP has not transferred the file in the proper format. Sorry if I'm belabouring this point, but...

Are you trying to read using a sequential file stage or a complex flat file stage?

Rob W

Rafidwh,

Do you have the file declared as a DOS file?

Look at the Line Termination section of the Stage tab. Ensure that the Unix Style (LF) radio button is checked.

Rob Wierdsma

chulett wrote:And the men who hold high places must be the ones to start
To mould a new reality closer to the heart...

You can be the captain, and I will draw the chart,
Sailing into destiny, closer to the heart.

Cool.

Ravi, Are you using data pulled in the first DB read as values to 'lookup' in the second DB stage? If so, you would define the values you want to lookup as keys in your second DB query, they would become part of the where clause. If you are trying to do something else, please provide some more detai...

Hi keshav,

Try the following links:

viewtopic.php?t=100238&highlight=timestamp+difference

viewtopic.php?t=89358&highlight=timestamp+difference

They should shed some light on techniques used by better men than us!

Rob Wierdsma

Hi sudhakar, Here's a couple of threads that will help you. http://www.dsxchange.com/viewtopic.php?t=100831&highlight=record+counts http://www.dsxchange.com/viewtopic.php?t=96468&highlight=record+counts http://www.dsxchange.com/viewtopic.php?t=91135&highlight=record+counts Rob Wierdsma

In that case if the data is really not big or if performance is not a big criteria you might wanna use server jobs for that. or as DSGURU2B suggested, try prep'ing the data even before sequential file stage reads it. Hi Kris, I have been trying to solve this issue going down both paths, EE and Serv...

Thanks, Guru!

Actually the more general case of UNIX and DOS EOR indicators (i.e. both x0A and x0D0A - and perhaps others?!?!?)

Rob

If you find a simpler way please let us know. IHTH Kris, Unfortunately, my task does not allow me to remove the embedded carriage returns, I need to maintain the format of the large text fields I am receiving. As a result, any eventual solution is not likely to aid you in your situation. I've been ...

Folks,

I'm trying to find where in a parallel sequential file stage I can specify 'Contains Terminators' as I would in a server job.

Is there such a beast?

Rob Wierdsma