Any One Help Me With An Example Program. How Can I Run SQR Program Through Process Scheduler.

Hi All,
I have the below requiremnet to add DESCRLONG column to the Input File(CSV) to load data from SQR to Job code Table,but there could be special character (Comma) ‘,’ in the DESCRLONG Column, So when I am trying to read data from CSV,it is treating ‘,’ (comma) in DESCR LONG Column as delimiter and remaining part after the Comma is getting assigned to the Next column.

I tried many ways to read the DESCRLONG column as single but unable to fix the Issue.

IN RUNCONTROL PAGE THER IS BUSINESS UNIT GRID IS THER ...VALUES ARE AA,BB,CC,DD,EE
FOR THAT MY REQUIRMENT IS I WANT A REPORT AS 'AA','BB','CC','DD','EE'
FROM DIS CODE
BEGIN-PROCEDURE Init-Report

LET $STR1 = ''

DO Select-Parameters

END-PROCEDURE

BEGIN-PROCEDURE Select-Parameters

BEGIN-SELECT
RC3.BUSINESS_UNIT &BUSINESS_UNIT
LET $BUSINESS_UNIT = &BUSINESS_UNIT
LET $STR1 = $STR1 || ''' ||$BUSINESS_UNIT|| '','

FROM PS_PES_MAC_SAT_BU RC3
WHERE RC3.OPRID = $prcs_oprid
AND RC3.RUN_CNTL_ID = $prcs_run_cntl_id
END-SELECT

I am comparing two folders. One is demo and the other one is custom. I have taken the common files in both the folder and put it in an array.
Now I need to get a list of modified files in the custom folder by calling cmd prompt command. Which command will be easier to get the solution?

Hi,

Does any one have sqr to write the data into a file with batch, header, detail info
010 batch
020 header
030 detailed

Thanks in Advance

Hi all,

Can any one tell me the what is dia critical charecters and How to use in SQR Coding?

can any one explain me with sample SQR example its an urgent requiremnt

please............

Thanks in advance
sudha

Hi All,
Kindly suggest me how to write the code in SQR to skip the last line while reading the flat file.

Example file:

1 ABC
2 xyz
000000000000