This page (revision-9) was last changed on 26-Nov-2021 10:22 by lurtan

This page was created on 26-Nov-2021 10:22 by RForbes

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
9 26-Nov-2021 10:22 2 KB lurtan to previous
8 26-Nov-2021 10:22 2 KB lurtan to previous | to last
7 26-Nov-2021 10:22 2 KB RForbes to previous | to last
6 26-Nov-2021 10:22 2 KB RForbes to previous | to last DERIVATION EXPRESSIONS ==> DERIVATION_EXPRESSION_USAGE
5 26-Nov-2021 10:22 2 KB RForbes to previous | to last
4 26-Nov-2021 10:22 2 KB RForbes to previous | to last
3 26-Nov-2021 10:22 2 KB RForbes to previous | to last
2 26-Nov-2021 10:22 2 KB RForbes to previous | to last
1 26-Nov-2021 10:22 2 KB RForbes to last

Page References

Incoming links Outgoing links

Version management

Difference between version and

At line 3 changed one line
This variable, if left alone will return a 672 byte value which is a concatenation of the values used in the generation of each record for the GL file.  Using the SQL substring function [SUBSTR], we can extract bits and pieces and manipulate it within the derivation expression
This variable, if left alone will return a 672 byte value which is a concatenation of the values used in the generation of each record for the GL file.  Using the SQL substring function [SUBSTR], we can extract bits and pieces and manipulate it within the derivation expression.
At line 5 added 5 lines
This can be used in quite sophisticated derivations, as shown in these examples:
# [Burden Code manipulation|GL BUFFER EXAMPLE 01]
The substring values for GL BUFFER are as follows: