CPG Release 2.6

COURSE in Limburg
13.5. – 15.5.2012
Vorschau auf Release 2.6
Michael Prinz
Lattwein GmbH
Copyright, 2012 Lattwein GmbH
NetPage UDATE und UTIME
CPG5.exe

Statistik mit SEND/RECEIVE Zeiten

Performance bei der Übertragung verbessert
CPG5 Statistik
QTCS TRACE STA
CPG5 Statistik
***QTCPMAIN*** Version 2.5 Trace = ST
CPG5 Statistik
CPG5 Messages

Bei einem Abbruch Fehlermeldung im Klartext
CPG5 Messages
CPG5.ini

LOGDATEI=2, LOG nur bei Fehlern
CPG5.ini
Universal Database

UDB Support – schon im Einsatz
UDB Definitionen
QQQQQ
2.5
PR
T222
09.05.12
13.54UHR
QQ
QQ
QQ
QQ
QQ
QQ
Q uery
QQ
U ser
QQ
I nformation
QQ QQ
C ontrol
QQQ
K it
QQQQQ QQ
QTF Library Service
------------------------------------------------------------------------------library
===>
TST2
password
===>
description
===>
Tests pr
dd library
===>
*
syntax (qpg) . , .
===>
U p d a t e
archive
type
control 1
qpg parameter
sql parameter user/passw ===>
Extended PWA
X
N/X
full stop / decimals / num. separator
CPGDBA
/
database
CPGDB
UDB Verarbeitung
Document KLIMADAT 4 Page 1
Line 36
Width
72
09.05.12 13.57UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
..
prog connudb sql.
..
sql declare c01 cursor for
+
..
insert into cpgdba.pl_klima_fakt
+
..
( land, plz, kljahr, klmona, mszrvo, mszrbi,
+
..
klifak, aenddt, opid )
+
..
values
+
..
( :land, :plz, :kljahr, :klmona, :mszrvo, :mszrbi,
+
..
:klifak, current timestamp, :opid )
..
sql open c01
..
cpgtsn = 'KLIMADAT'
..
count = 100.
..
do 10000 recnr
..
recnr read klimadat
..
if cpgfrc = 'EF'
..
break
..
endif
..
evaluate.
..
when recnr = 1.
..
mszvo = parmt.
..
when recnr = 2.
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
F3=End
Erweiterte Editcodes

Edit – Minus nach vorne für Excel
Erweiterte Editcodes
Document EDITCODE 4 Page 1
Line 1
Width
72
09.05.12 13.58UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Test Editcode - für Excel
TEST.EDITCODE
.. *----------------------------------------------------------------------.. -d
..
wert
7 2
..
ausg
80
.. -c
..
wert = -6666,66
..
debug on
..
edit ausg
..
'QPCF' list editcode
..
prog showqpcf
.. -o
..
field ausg sep '|'
..
wert edit j '-'
..
wert edit k '-'
..
wert edit l '-'
..
wert edit m '-'
.. **** end ****
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
Erweiterte Edit-Codes
Document EDITCODE 5 Page 1
Line 1
Width
72
09.05.12 13.59UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. Ausgabe Normal
.. §nametab wert:rj,wert:rk,wert:rl,wert:rm
..
%
..
%
..
%
..
%
.. Ausgabe Excel
.. §nametab wert:-jr,wert:-kr,wert:-lr,wert:-mr
..
%
..
%
..
%
..
%
.. Ausgabe Schutzstern
.. §nametab wert:*jr,wert:*kr,wert:*lr,wert:*mr
..
%
..
%
..
%
..
%
.. Ausgabe Währungszeichen
.. §nametab wert:$jr,wert:$kr,wert:$lr,wert:$mr
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
F3=End
Erweiterte Editcodes
qpgepd
online debug facility
2.5 PR
T222 09.05.12 14.00UHR
-----------------------------------------------------------------------------program
: EDITCODE
library :
TEST
statement number :
3
transaction
: QTF
task-Nr. :
64031
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
EDIT
:
:
result field
service
:
:
field display
:
file return code :
,
,
AUSG
,
....+....1....+....2....+....3..
-6.666,66| -6.666,66| -6666,66|
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
Erweiterte Editcodes
prpage
ab
20
09.05.12 14.01UHR
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
Ausgabe Normal
6.666,666.666,666666,666666,66Ausgabe Excel
-6.666,66
-6.666,66
-6666,66
-6666,66
Ausgabe Schutzstern
*6.666,66*6.666,66*6666,66*6666,66Ausgabe Währungszeichen
$6.666,66$6.666,66$6666,66$6666,66....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
End of File
0000020
QPG Operationen
 TEST-FIELD

für numerische Felder
ELIM DELC und REPLC
TEST-Field
Document TESTN
6 Page 1
Line 1
Width
72
09.05.12 11.46UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Test Numeric
TEST.TESTN
.. *----------------------------------------------------------------------.. -d
..
wert
7 2.
* zu prüfendes feld
..
rc
1.
* returncode N=numerisch
..
msg
18.
* message
.. -c
..
debug on
..
wert = '123,45'
..
perform testfld.
* test field
..
wert = '765432-'
..
perform testfld.
* test field
.. testfld begsr
..
test-field wert rc
..
if rc = 'N'
..
msg = 'Feld ist numerisch'
..
else
..
msg = 'Feld ist ungueltig'
..
debug
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
F3=End
TEST-Field
qpgepd
online debug facility
2.5 PR
T222 09.05.12 11.40UHR
-----------------------------------------------------------------------------program
: TESTN
library :
TEST
statement number :
7
transaction
: QTF
task-Nr. :
63216
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
field display
TESTF
file return code :
WERT
,
,
:
:
RC
,
:
WERT
,
0123?45
....+....1....+....2....+....3..
0123?45
02B5
PWA + 098
134F
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
ELIM, DELC und REPLC
Document ELIM
6 Page 1
Line 1
Width
72
09.05.12 11.50UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Course 2012 in Limburg
TEST.ELIM
.. *----------------------------------------------------------------------.. -d
..
satz
80
.. -c
..
debug on
..
satz = 'Dieser Satz hat keine Vokale'
..
elim 'aeiouAEIOU' satz
..
satz = 'Dieser Satz hat keine Vokale'
..
delc 'aeiouAEIOU' satz
..
satz = 'Dieser Satz hat keine Vokale'
..
'aeiouAEIOU' replc '-' satz
.. **** end ****
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
ELIM, DELC und REPLC
qpgepd
online debug facility
2.5 PR
T222 09.05.12 11.51UHR
-----------------------------------------------------------------------------program
: ELIM
library :
TEST
statement number :
2
transaction
: QTF
task-Nr. :
63271
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
=
file return code :
,
,
SATZ
,
Dieser Satz hat keine Vokale
....+....1....+....2....+....3..
Dieser Satz hat keine Vokale
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
ELIM
qpgepd
online debug facility
2.5 PR
T222 09.05.12 11.51UHR
-----------------------------------------------------------------------------program
: ELIM
library :
TEST
statement number :
3
transaction
: QTF
task-Nr. :
63271
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
ELIM
file return code :
,
,
SATZ
,
aeiouAEIOU
....+....1....+....2....+....3..
D s r S tz h t k n V k l
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
DELC
qpgepd
online debug facility
2.5 PR
T222 09.05.12 11.51UHR
-----------------------------------------------------------------------------program
: ELIM
library :
TEST
statement number :
5
transaction
: QTF
task-Nr. :
63271
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
DELC
file return code :
,
,
SATZ
,
aeiouAEIOU
....+....1....+....2....+....3..
Dsr Stz ht kn Vkl
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
REPLC
qpgepd
online debug facility
2.5 PR
T222 09.05.12 11.51UHR
-----------------------------------------------------------------------------program
: ELIM
library :
TEST
statement number :
7
transaction
: QTF
task-Nr. :
63271
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
REPLC
file return code :
,
,
SATZ
,
aeiouAEIOU
....+....1....+....2....+....3..
D--s-r S-tz h-t k--n- V-k-l-
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
REPLC Beispiel EAN8
Document EAN8
6 Page 1
Line 1
Width
72
09.05.12 12.00UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
EAN8 Barcode ermitteln
TEST.EAN8
.. *----------------------------------------------------------------------.. -d
..
eingab
8 0.
* eingabe ean8 ziffern
..
ausgab
11.
* ausgabe ean8 code
..
cpgeds
0 *
1.
* ----------------------..
ein
0 *
8.
* eingabe
..
ein1
4.
* eingabe 1-4
..
ein2
4.
* eingabe 5-8
.. -c
..
debug on
..
eingab = 12345678
..
ein = eingab
..
'0123456789' replc ':;<=>?@ABC' ein1
..
'0123456789' replc 'NOPQRSTUVW' ein2
..
edit ausgab
.. -o
..
field ausgab
..
'"' + ein1 + '#' + ein2 + '"'
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
REPLC Beispiel EAN8
qpgepd
online debug facility
2.5 PR
T222 09.05.12 12.04UHR
-----------------------------------------------------------------------------program
: EAN8
library :
TEST
statement number :
4
transaction
: QTF
task-Nr. :
63342
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
REPLC
file return code :
,
,
EIN1
,
0123456789
:;<=>?@ABC
....+....1....+....2....+....3..
;<=>
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
REPLC Beispiel EAN8
qpgepd
online debug facility
2.5 PR
T222 09.05.12 12.02UHR
-----------------------------------------------------------------------------program
: EAN8
library :
TEST
statement number :
5
transaction
: QTF
task-Nr. :
63333
function key
:
DE
module
: HPROG
restart pf-key
:
-----------------------------------------------------------------------------after operation:
factor1
factor2
:
:
result field
service
:
:
field display
:
REPLC
file return code :
,
,
EIN2
,
0123456789
NOPQRSTUVW
....+....1....+....2....+....3..
STUV
,
....+....1....+....2....+....3..
-----------------------------------------------------------------------------enter: next
pf4 : trace conditions
pf8 : field display
clear: exit
pf1 : help
pf5 : screendump
pf9 : program display
pf2 : userscreen pf6 : log single record pf10: map
displ/pr:
pf3 : end trace pf7 : log no display
pf11: dump
pf12: endpr
QTF LIST
 Verketten

numerischer Felder
Powerliste im Batch segmentieren
LIST verketten num. Felder
Document C2012L
6 Page 1
Line 1
Width
72
09.05.12 12.04UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Course 2012 Limburg - List num. Felder
TEST.C2012L
.. *----------------------------------------------------------------------.. -d
..
zeile
3 0.
* line counter
..
msg
64.
* message
.. -c
..
do 100 zeile
..
'QPCF' list c2012l
..
enddo
..
prog showqpcf
.. **** end ****
..
..
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
LIST verketten num. Felder
Document C2012L
7 Page 1
Line 1
Width
72
09.05.12 12.06UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. §nametab zeile:z&
.. %. Zeile
.. **** end ****
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
LIST verketten num. Felder
prpage
ab
21
09.05.12 12.07UHR
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
1. Zeile
2. Zeile
3. Zeile
4. Zeile
5. Zeile
6. Zeile
7. Zeile
8. Zeile
9. Zeile
10. Zeile
11. Zeile
12. Zeile
13. Zeile
14. Zeile
15. Zeile
16. Zeile
17. Zeile
18. Zeile
19. Zeile
20. Zeile
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
0000021
Powerliste im Batch segmentieren
Document C2012P
6 Page 1
Line 1
Width
72
09.05.12 12.08UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Course 2012 Limburg - List Segment
TEST.C2012P
.. *----------------------------------------------------------------------.. options dat
.. -d
..
stmt
72
..
seg
3 0
.. -i
..
file hplseg hs
..
1
72
stmt
.. -c
..
list c2012p header
..
do 10 seg
..
edit stmt.
.. **
exhm hplseg hplseg.
* segmentieren
..
list c2012p segmnt
..
enddo
.. -o
..
field stmt
..
'* $$ LST JNM=LCP' + seg
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
Powerliste im Batch segmentieren
Document C2012P
7 Page 1
Line 1
Width
72
09.05.12 12.10UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. §section header
.. §newpage
.. §nametab seg:z
.. *----------------------------------------------------------------------.. *
Test Powerliste segmentieren Anfang
LIST.C2012P
.. *----------------------------------------------------------------------..
.. §section segmnt
.. §segment
.. * $$ LST JNM=LCP§seg:zs
.. §newpage
.. §nametab seg:z
.. *----------------------------------------------------------------------.. *
Test Powerliste segmentieren %%%. Segment
LIST.C2012P
.. *----------------------------------------------------------------------..
.. **** end ****
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
Powerliste im Batch segmentieren
Document C2012P
7 Page 1
Line 1
Width
72
09.05.12 12.16UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. * $$ JOB JNM=LCP,DISP=D,CLASS=A
.. * $$ LST CLASS=L
.. // JOB PRINZ
.. // EXEC QPGUTIL,SIZE=AUTO
.. C2012P
TEST
.. /*
.. /&
.. * $$ EOJ
.. **** end ****
..
..
..
..
..
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
Powerliste im Batch segmentieren
-> dq lst,lcp
SESS=A 1( 1) LINE=
0(
15)
----¦----1----¦----2----¦----3----¦----4----¦----5----¦----6----¦----7----¦----- TOP OF DISPLAY ------------------------------------------------------------------------------------ POWER JOB ----- P D C S CARDS/ CPY FORM ORIGIN/
USER INFO
DES
QUE
NAME NUMBER SG
PAGES
DEST
NODE
--- -------- ----- -- - - - - ------- --- ---- -------- ---------------- -----LST LCP
46928
5 D L
1
1
LST LCP1
46929
5 D L
1
1
LST LCP2
46930
5 D L
1
1
LST LCP3
46931
5 D L
1
1
LST LCP4
46932
5 D L
1
1
LST LCP5
46933
5 D L
1
1
LST LCP6
46934
5 D L
1
1
LST LCP7
46935
5 D L
1
1
LST LCP8
46936
5 D L
1
1
LST LCP9
46937
5 D L
1
1
LST LCP10
46938
5 D L
1
1
-- END OF DISPLAY --
QPGUTIL

Batchprogramme mit Daten aufrufen
Batchprogramme mit Daten
Document PRDATA
7 Page 1
Line 1
Width
72
09.05.12 12.20UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. *----------------------------------------------------------------------.. *
Aufruf QPGUTIL mit Daten
TEST.PRDATA
.. *----------------------------------------------------------------------.. -d
..
prdata
40 *
1.
* program data
.. -i
..
array prdata
..
1
8
ddname
..
9
10
ddtype
.. -c
..
selct prdata
..
ddname dsply
.. **** end ****
..
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
Batchprogramme mit Daten
Document QPGUTIL1 6 Page 1
Line 1
Width
72
09.05.12 12.21UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
.. * $$ JOB JNM=LCP,DISP=D,CLASS=A
.. * $$ LST CLASS=L,FNO=0112,FCB=FCB12,DEST=(*,PR)
.. * $$ PUN CLASS=L
.. // JOB PRINZ
.. // EXEC QPGUTIL,SIZE=AUTO
.. PRDATA
TEST
DATEI
SA
.. /*
<...+....1....+....2..PRDATA.3....+....>
.. /*
.. /&
.. * $$ EOJ
.. **** end ****
..
..
..
..
..
..
..
..
..
....+....1....+....2....+....3....+....4....+....5....+....6....+....7.<..+.
End of document.
F3=End
HL1 Batch

Konfiguration EF für Empty Files
Empty Files
Document LISTFILA 6 Page 1
Line 1
Width
80
09.05.12 12.25UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
.. * $$ JOB JNM=LCP,CLASS=A
.. * $$ PRT CLASS=L
.. // JOB PRINZ
.. // EXEC HL1,SIZE=(AUTO,256K)
..
OPTIONS BATCH PHASE TESTPR END.
..
FILE CPGKSD INP V 500 20 KSDS NO.
* NO OPEN
..
- -I.
..
FILE CPGKSD.
..
1 100
SATZ
..
- -C.
..
OPEN CPGKSD INP.
..
ON EF GOTO ENDE.
* EMPTY FILE
..
LIST TESTPR HEADER
..
DO 10
..
READ CPGKSD.
..
ON EF BREAK
..
LIST TESTPR DETAIL
..
ENDDO
..
LIST TESTPR TRAILR
..
ENDE.
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
F3=End
Empty Files
CATALS A.CPGUCSIT
BKEND
PUNCH '
CATALR CPGURSIT'
*
CPGURSIT CSECT
*
*---------------------------------------------------------------------*
*
S Y S T E M
KONFIGURATION
*
*---------------------------------------------------------------------*
CWAOFSET DC
F'0'
1-4
*
*
DC
CL28'CYYY6,YYYJYNTX
'
*
DC
CL08'CYYY7,YY'
5-12
*
*
DC
CL8'5...10..'
*
DC
CL8' JYN5GY '
13-20
*
*
DC
CL8'..5...20'
*
DC
CL8'T$ UASYE'
21-28
25=A
*
*
DC
CL8'...25...'
*
DC
XL4'6E83EF40'
29-32
PR 200611 *
*
DC
XL4'. 30 . .'
*
* STELLE 10
= 7
CICS 1.7 VSE SP4 1.9.90
*
* STELLE 14
= D,I,J,' ' GIBT DIE STELLE 21
*
*
DER RPGII H-KARTE WIEDER | NEUES ERFEC+ERTEC ERFORDERLICH
*
* STELLE 16
= N ABEND BEI PF1 NUR
*
* STELLE 31
= X'40' BATCH ABBRUCH INITIAL OPEN LEERE VSAM DATEI
*
*
= X'EF' BATCH KEIN ABBRUCH, ERSTES READ BRINGT EF
*
Empty Files
Document LISTFILE 6 Page 1
Line 1
Width
80
09.05.12 13.06UHR
. ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
.. * $$ JOB JNM=LCP,CLASS=A
.. * $$ PRT CLASS=L
.. // JOB PRINZ
.. // EXEC HL1,SIZE=(AUTO,256K)
..
OPTIONS BATCH PHASE TESTPR END.
..
FILE CPGKSD INP.
..
- -I.
..
FILE CPGKSD.
..
1 100
SATZ
..
- -C.
..
LIST TESTPR HEADER
..
DO 10
..
READ CPGKSD.
..
ON EF BREAK
..
LIST TESTPR DETAIL
..
ENDDO
..
LIST TESTPR TRAILR
.. /*
.. // EXEC PROC=$$SYSIN
.. // EXEC LNKEDT
....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+.
F3=End
Query

Suchen Case Independent

Minus nach vorne

Edit-Code I für ISO-Datum
Suchen Case independent
Programs Query Report
2.6
PR
T223 09.05.12 13.09UHR
-----------------------------------------------------------------------------C2012K
H C2012K
HDR='Kundenliste',INFO=N,SB=PR,SEP=' ',DEZAP=Y,
C2012K
F CPGKDN
CPG KUNDEN PFLEGEN
C2012K
C CPGKDN
FIRMA
* 'Handel'
Y
C2012K
O CPGKDN
KDNR,FIRMA,PLZ,ORT,
-----------------------------------------------------------------------------Browse data End
Press ENTER to continue
Suchen Case independent
Query Report C2012K
2.6
PR
T223 09.05.12 13.10UHR
-----------------------------------------------------------------------------Kundenliste
Q U E R Y C2012K PR 09.05.12
13.
-----------------------------------------------------------------------------KDNR FIRMA
PLZ
ORT
-----------------------------------------------------------------------------304 Berufsgenossenschaft Handel
68161 Mannheim
663 RHEIKA-DELTA Warenhandels34212 Melsungen
664 EDEKA Handelsg.Hessenring mbH 34212 Melsungen
665 EDEKA Handelsgesellschaft
47441 Moers
809 PHOENIX Pharmahandel GmbH & Co 90765 Fürth
2508 Berufsgenossenschaft Handel
53113 Bonn
5021 EDEKA Handelsgesellschaft
34212 Melsungen
5022 EDEKA Handelsgesellschaft
34212 Melsungen
5024 EDEKA Handelsgesellschaft
34212 Melsungen
5025 EDEKA Handelsgesellschaft
34212 Melsungen
5026 EDEKA Handelsgesellschaft
34212 Melsungen
5027 EDEKA Handelsgesellschaft
34212 Melsungen
5046 Berufsgenossenschaft Handel
68161 Mannheim
8103 Handelsblatt GmbH
40210 Düsseldorf
8113 Handelsgesellschaft m.b.H
4050 Mönchengladbach
8159 WPG Pharm. Großhandel
97076 Würzburg
-----------------------------------------------------------------------------PF7=Left
PF8=Right
PF4=Output
Data entry
Minus nach vorne
QQQQQ
2.6
PR
T223 09.05.12 13.12UHR
QQ
QQ
Q uery
Wednesday CICSTEST
QQ
QQ
U ser
Q2IEDD02
QQ
QQ
I nformation
QQ
QQ QQ
C ontrol
QQ
QQQ
K it
QQQQQ QQ
Data Dictionary
-----------------------------------------------------------------------------File-name ...... CPGWRK
TP
Library ....
Field name ..... N1
Start-position .
20
End position ...
20
Decimal places . 0
packed/binary ..
Edit code ...... M
Description .... unpacked
Maintenance ....
Key field ......
No. of elements.
Generate ....... H
-----------------------------------------------------------------------------N1
change
Press ENTER To continue
Minus vorne und ISO-Datum
Data Dictionary
2.6
PR
T223
09.05.12
13.31UHR
Q2DEDD03
Field
from
to Byte P Arr Lng
E C K G Description
------------------------------------------------------------------------------KEY
1
14
14
14
Y
J63
15
20
6
6,3 J
M63
15
20
6
6,3 M
N6
15
20
6
6,0 M
unpacked
N63
15
20
6
6,3
N5
16
20
5
5,0 M Unpacked Sign Left
N4
17
20
4
4,0 M $
N3
18
20
3
3,0 M *
N1
20
20
1
1,0 M H Unpacked Sign Left
B4
21
24
4 B
9,0 M
binary
P7
21
24
4 P
7,0 M
Q packed
P5
22
24
3 P
5,0 M
packed
B2
23
24
2 B
4,0 M
binary
P3
23
24
2 P
3,0 M
packed
P1
24
24
1 P
1,0 M
packed
L6
25
27
3 L
6,0 M
log.gepackt
L4
26
27
2 L
4,0 M
log.gepackt
ISODAT
31
38
8
8,0 I
Format JJJJMMTT
------------------------------------------------------------------------------CPGWRK
TP
browse Press ENTER
PF7 backwards PF4/5 Print
L86C
Minus nach vorne und ISO-Datum
Programs Query Report
2.6
PR
T222 09.05.12 13.35UHR
------------------------------------------------------------------------------TPR
H TPR
HDR='Test Pr',INFO=S,SB=PR,SEP=' ',FL=00,KEY='99TPR',DEZ
TPR
F CPGWRK
TP SAMMMELDATEI FUER TOP
TPR
O CPGWRK
TP KEY,N1,N3,N5,ISODAT
------------------------------------------------------------------------------Browse data End
Press ENTER to continue
Minus nach vorne und ISO-Datum
Query Report TPR
2.6
PR
T222 09.05.12 13.37UHR
------------------------------------------------------------------------------Test Pr
Q U E R Y TPR
PR 09.05.12
13.3
------------------------------------------------------------------------------KEY
N1
N3
N5
ISODAT
------------------------------------------------------------------------------99TPR
3 123
123 12.01.2011
99TPR0
***
99TPR2
2 **2
2
99TPR3
-1 *21-21
99TPR4
-3 *33-33
------------------------------------------------------------------------------PF7=Left
PF8=Right
PF4=Output
Data entry
ISO-Datum
Online Ditto
File: CPGWRK
2.6
PR
T222 09.05.12 13.38UHR
------------------------------------------------------------------------------Key: 99TPR
99TPR
000123
20110112
FFEDD444444444FFFFFF4444444444FFFFFFFF44444444444444444444444444444444444444444
9937900000000000012300000000002011011200000000000000000000000000000000000000000
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....
1
2
3
4
5
6
7
44444444444444444444
00000000000000000000
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....
9
10
11
12
13
14
15
1
Query im Browser
 Anzeige
für Feldgruppen (+) und (*)
Feldgruppen (+) und (*)
Feldgruppen (+) und (*)
CPG Statistik

CPGSTA mit QPG Library
CPG Statistik
QQQQQ
2.5 PR
T222 09.05.12 13.40UHR
QQ
QQ
Q uery
Wednesday CICSTEST
QQ
QQ
U ser
QQ
QQ
I nformation
QQ
QQ QQ
C ontrol
QQ
QQQ
K it
QQQQQ QQ
quick program manager
------------------------------------------------------------------------------Reference
P
name/value
C
D
F
H
K
L
M
N
P
T
operation code
data dictionary, type
file
modul (hl1)
constant
list document
map (qsf/netpage)
fieldname
program (qpg)
trans-id
library
F2 global reference
CPGSTA mit QPG Library
QQQQQ
2.6
QQ
QQ
QQ
QQ
QQ
PR
T222
09.05.12 13.42hrs
Wednesday CICSTEST
QQ
Q uery
QQ
U ser
QQ
I nformation
QQ QQ
C ontrol
QQQ
K it
QQQQQ QQ
quick program manager
------------------------------------------------------------------------------Global Reference
P
name
TBZ1
F
H
L
M
N
P
T
X
file
modul (hl1)
list document
map (qsf/netpage)
fieldname
program (qpg)
trans-id
exitp/expr (cpg)
CPGSTA mit QPG Library
Global Reference
program TBZ1
Library Programs
TEST
TBZFIND
*CPG
HMTBZ
HMZQPG1
End of reference
TBZQPG1
2.6
XX
PR
T222
09.05.12
13.43hrs
CPGSTA mit QPG Library
Online Ditto
File: CPGSTA
2.6
PR
T223 09.05.12 13.45UHR
------------------------------------------------------------------------------Key: P TBZ
001
P TBZ
001
TEST
4 TBZ1
5 CPG5
4 TBZ2
5 LIB1
4 P
D4ECE444444444444FFF14444444ECEEFFFFF4ECEF4444F4CDCFFFFFF4ECEF4444F4DCCFFFFFF4D
70329000000000000001400000003523FFFF4032910000503775FFFF4032920000503921FFFF407
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....
1
2
3
4
5
6
7
Z2
3 PBZ3
3 LIB2
4 PBZ4
3 PBZ5
3 LIB1
4 PBZ2
3 LIB1
4 P
EF4444F4DCEF4444F4DCCFFFFFF4DCEF4444F4DCEF4444F4DCCFFFFFF4DCEF4444F4DCCFFFFFF4D
9200003072930000303922FFFF40729400003072950000303921FFFF4072920000303921FFFF407
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....
9
10
11
12
13
14
15
1
Z6
3 'TT25' 1
EF4444F47EEFF744F4FFFFFFFFFF
96000030D3325D0010FFFFFFFFFF
....5....0....5....0....5....0....5....0....5....0....5....0....5....0....5....
17
18
19
20
21
22
23
2
CPG5 Release 2.6
Noch Fragen ???
Vielen Dank für Ihre Aufmerksamkeit !