Add Leading Characters to a Value or Field
摘要:A function to facilitate the addition of a leading character to a field value. The function takes three parameters:- &LEADCHAR: The character you want to append to your value.- &FIELDZISE: The...
阅读全文
Read Env Variables from an SQR
摘要:Get the O/S environment variables from within SQR programs There is a function called GetEnv(). This gets the TEMP environment variable on the machine where SQR is run. Returns the value of the spec...
阅读全文
Calling a Batch File/EXE from an SQR
摘要:Use the following code to call a batch file or executable from an SQR. Put the complete path of the batch or executable in the variable $command_line. If $message is not 0 then you have an error from ...
阅读全文
Strip out additional chars from Phone Numbers
摘要:Below is a good SQR tip for stripping out special characters from those nasty Phone Number formats stored in HRMS. begin-procedure main . . do parse_phone($phone_number, $phone_number) . . end-proc...
阅读全文
Use an SQR to call DataMover to Export then call a
摘要:Below is a sample piece of SQR code which you can use to call Datamover to export data perform some processing, and call another SQR within that SQR to posibly load the data. It's a good sample! !**...
阅读全文