A SQL export of all data (including all alternate ALU/UPC values) for RP9 users with RGIS is saved at:
T:sqlqueriesv9rgisRGIS_ALL.bat
Moving the *.BAT and *.SQL files over to the client’s RP9 machine, and then run the *.BAT file. The result will be a TAB and CSV delimited file created in the same directory as the *.BAT file.
Specs of the SQL query are below:
SET PAGESIZE 0
SET NEWPAGE 0
SET SPACE 0
SET LINESIZE 132
SET ECHO OFF
SET FEEDBACK OFF
SET VERIFY OFF
SET HEADING OFF
SET COLSEP ‘,’
set trim on
set term off
set wrap off
set trimspool on
set trimout on
spool rgis_all.csv
select p.description1||chr(44)||p.local_upc||chr(44)||p.alu||chr(44)||p.item_no||chr(44)||invn_sbs_vendor.alu||chr(44)||invn_sbs_vendor.upc from invn_sbs p
left join invn_sbs_vendor on p.item_sid = invn_sbs_vendor.item_sid
where p.active=1;
spool off
spool rgis_all.tab
select p.description1||chr(44)||p.local_upc||chr(44)||p.alu||chr(44)||p.item_no||chr(44)||invn_sbs_vendor.alu||chr(44)||invn_sbs_vendor.upc from invn_sbs p
left join invn_sbs_vendor on p.item_sid = invn_sbs_vendor.item_sid
where p.active=1;
spool off