I have a file called X - and there is some reports that have specific information that is needed - so the only way I can do this is by creating an sql statement in the extractor. Which is fine, but if I am creating 5 sql statements to pull the data differently into different tables will this cause a problem does anyone know or should I not be doing this?
example
//****************************INVOICED ORDERS INVOICED TABLE****************************
INVOICEDORDERS:
SELECT SAORD, SABOCD, SAINDT, SACMP, SATYPE
FROM
STORE
Table INVOICEDORDERS;
//***************************************************************************
compared to this sql statement
//*************************************************************************************************
// New entry on 012411 - count the number of credits only for R and C 003 and higher reason
//*****************************ORDER HEADER for Credits only for History TABLE************************
VSAHEAD:
SQL SELECT SACRES, SAORDS, SATYPE, SAINDT, SACMP, SAORD, SABOCD
SACRES > '002' AND
STORE
VSAHEAD into $(Folder_Path) NumberOfCredits_VSAHEAD.qvd (qvd);
DROP
//***************************************************************************