Hi, Im using a File Listener to read flat source from a fol...

[Manoj Chaurasia]

Hi Thirumaran

You could run a stored procedure before the load that does a

TABLE FILE flatfile

PRINT *

ON TABLE HOLD

END

-RUN

-TYPE Source Row Count: &LINES

The -TYPE should show up in the log but to be honest I didnt test it

[Manoj Chaurasia]

chuck.wolff:

 

flatfile

 

 

Chuck, Thanks for your reply.

In the flat file synonym, Im using DATA_ORGIN= LISTENER and archiving the flat-file post processing. So if I run the code that you suggested, the flat file moved to the Archive folder.

I need to check the source record count before processing that flat file.

[Manoj Chaurasia]

Thirumaran

You could create a separate master file without the DATA_ORIGIN to use for this portion of the processing

[Manoj Chaurasia]

Hi,

Im using a File Listener to read flat source from a folder and move to archive folder after processing. Is there any way to get the source file record count before the source file process Because the user wants to check if the source file record count and the target table record counts are the same.

[Manoj Chaurasia]

Thanks Chuck. I used this method and its working fine.