SQL Anywhere
Good Afternoon,
I have been tasked to create a business case for transferring our current day to day data management from our current systems. After my 3rd wave of presentations for this I was presented with the following SQL. I know I can recreate this via Automation using the IF/Then widget, but the senior programmer that sent this over doesn't like how complicated the automation looks once I reproduced it.
I know the below doesn't work in editor natively because 1) I tried and 2) the IF GOTO & OUTPUT statements are custom to our internal software we use.
My question is there a Toad equivalency to the below? or is there a way to define the IF GOTO & Output statements in the settings so that Toad can recognize the below SQL Statement?
SELECT COUNT(*) FROM Insp WHERE DateRec = '2024/5/10';
IF (%RecordCount%=0) GOTO Done;
[Thousands]
SELECT CustID, LoanNumDisp, Requestor, InspID, DateRec
FROM InspAll
WHERE DateRec = '2024/5/10'
AND InspID LIKE '%000';
IF (%RecordCount%=0) GOTO DoTenThousands;
output TO 'c:\tempfiles\Thousands.xlsx' format excel field headers overwrite openafter;
[DoTenThousands]
SELECT CustID, LoanNumDisp, Requestor, InspID, DateRec
FROM InspAll
WHERE DateRec = '2024/5/10'
AND InspID LIKE '%0000';
IF (%RecordCount%=0) GOTO DoHundredThousands;
output TO 'c:\tempfiles\TenThousands.xlsx' format excel field headers overwrite openafter;
[HundredThousands]
SELECT CustID, LoanNumDisp, Requestor, InspID, DateRec
FROM InspAll
WHERE DateRec = '2024/5/10'
AND InspID LIKE '%00000';
IF (%RecordCount%=0) GOTO Donoe;
output TO 'c:\tempfiles\HundredThousands.xlsx' format excel field headers overwrite openafter;