Problem using PS Query

[TDKID]

Which one is best PS Query or SQR

Actually my scenario is this I need to extract data from PeopleSoft database and store it into ASCII file, which I use it for loading into my Data warehouse.

If I use PS Query its performance is good because it’s a PeopleSoft tool itself compared to SQR which is a third party tool.

The problem I face in PS Query is that the output cannot be saved into CSV file or any other text format without user clicking on the export to excel icon then save it as CSV. Is there a way where I can write a script so that the output from PS Query is directly stored as text file (with specific delimiter if possible) which is possible using SQR.

I am basically a Data warehouse guy so if I am wrong in PeopleSoft terms please correct me.

Thanks in advance.

 

[tzamora]

You could try concatenating in a ps_query expression...

i.e.

select tAP3L.BUSINESS_UNIT||'`'||tAP3H.journal_id
FROM PS_JRNL_HEADER tAP3H,
PS_JRNL_LN tAP3L

http://programmer-by-the-hour.com

 

[jimuk55]

Why don't you merge the two?

Create the PS QUERY, click on the SQL tab, select the SQL statement, then copy 'n' paste this into your SQR?

Then you can use SQR to convert this to an ASCII file for you.

Jim