'Hi, i use sqr write command to write strings to a flat file. When i run my sqr from windows, it wrote to the flat file 1 string per line. But when i run from unix, it wrote all of string to one line.

But if i use wordpad to open the file. It show correct result (1 string /line). The problem is when my sqr run on unix.

It issues a error: writing error because all string in 1 line so it go over 1025 chars. Does anyone have run it this problem and know how to solve it? //*-------- INTERESTED IN THIS MESSAGE? RELATED CONTENT -------- Intelligent Document Delivery: The Ins and Outs of Business Process ROI With Oracle ERP (White Papers) Adam loves Eve, who loves Oracle?

(Blogs) Project leader (Wiki) RE: Report on Security (Groups) -------------------------------------------------------------*// '. Its a long time since I did any SQR on Unix, however in Dos based systems (windows etc) a simple CR will set the curser to column 1 on the next line. In Unix you have to issue a CR and EOL controls - as you have found out.

We will discuss about Print command in detail in coming sections of the document. We can run an SQR through PeopleSoft by associating it with one of the.

I'm sure others will correct me if my memory is bad. On 12/29/06, ps_sp007 via peoplesoft-hr-l wrote: >>>>Hi, i use sqr write command to write strings to a flat file. When >i run my sqr from windows, it wrote to the flat file 1 string >per line. But when i run from unix, it wrote all of string to >one line. But if i use wordpad to open the file. It show correct >result (1 string /line). The problem is when my sqr run on unix.

>it issues a error: writing error because all string in 1 line so >it go over 1025 chars. Does anyone have run it this problem and >know how to solve it?

>>>>>>>//*-------- INTERESTED IN THIS MESSAGE? RELATED CONTENT -------- Intelligent Document Delivery: The Ins and Outs of Business Process ROI With Oracle ERP (White Papers) Adam loves Eve, who loves Oracle? (Blogs) PeopleSoft (Wiki) RE: Report on Security (Groups) -------------------------------------------------------------*//.

Just use newline command to carry the cursor to the new line to get next string in the ne line since unix doesnt do it. Cafa123 via peoplesoft-hr-l wrote: its a long time since I did any SQR on Unix, however in Dos based systems (windows etc) a simple CR will set the curser to column 1 on the next line. In Unix you have to issue a CR and EOL controls - as you have found out. I'm sure others will correct me if my memory is bad. On 12/29/06, ps_sp007 via peoplesoft-hr-l wrote: >>>>Hi, i use sqr write command to write strings to a flat file. When >i run my sqr from windows, it wrote to the flat file 1 string >per line. But when i run from unix, it wrote all of string to >one line.

But if i use wordpad to open the file. It show correct >result (1 string /line). The problem is when my sqr run on unix. >it issues a error: writing error because all string in 1 line so >it go over 1025 chars.

Does anyone have run it this problem and >know how to solve it? >>>>>>>__________________________________________________ Do You Yahoo!? Tired of spam?

Mail has the best spam protection around //*-------- INTERESTED IN THIS MESSAGE? RELATED CONTENT -------- Intelligent Document Delivery: The Ins and Outs of Business Process ROI With Oracle ERP (White Papers) OpenWorld is Now Closed (Blogs) What are BIW and BW? Why do they have a significant role in Enterprise Resource Planning? (Wiki) RE: Report on Security (Groups) -------------------------------------------------------------*//. Are you using a PRINT command or a WRITE command in SQR? Hp Ilo Firmware Dl380 G4 Motherboard more. Writing data is for creating a flat data file.