Search results

Hi, I'm attempting to import a text file into a temp table so I can perform some calculations on data held within it. I'm struggling as I've only managed to upload a file in the past where only 1 delimiter was needed and the columns were laid out nicely. Basically I have a temp table at the...

Hi, I'm wondering is someone can help me speed up an upload of data I'm trying to perform. I'm new to this so haven't much experience but I've managed to piece together the below which works fine although I would expect it to complete within a few seconds instead it's taking 45 seconds a go...

Hi, I'm struggling to get my frame which is being displayed to the terminal to scroll up/down. At the moment I can only navigate by pressing space bar/carriage return in which case it moves downwards but then won't let you scroll back up or move around using the arrow keys. Any help would be...

Hi, When running the below code and selecting the file-btn it doesn't run the procedure within the SET statement (fileOutputReport), the MESSAGE statement works so I know the variable is populated with the data entered by the user however it doesn't go ahead and OUTPUT TO the file which is the...

Hi, I'm trying to use the wildcard "*" with the variable cReasonCode so that in the Where clause when you enter "*" it matches all records. Currently it's literally searching for the character "*" and not treating it as a wildcard. Any help would be greatly appreciated. DEFINE VARIABLE...