var searchtexts = new Array ('20last Undgå stress/Avoid stress;;STRESS' ,'202013*Corona virus pause;;CORONA' ,'202013 Corona virus pause;;CORONA' ,'202011*Faster SQL statements in REXX also for INSERT/UPDATE/DELETE;;REXX SQL USING HOSTVARIABLE' ,'202009 Language Environment (LE) options;;LE JCL' ,'202007*Using the DB2 command DSN from REXX;;DB2 DSN PULL PUSH REXX' ,'202005 Totaler over flere kolonner i SQL;;SQL ROLLUP CUBE GROUPING SETS' ,'202003*Release unused space in VSAM datasets;;ADRDSSU RELEASE DB2 STOP START' ,'202001 Konvertering af heltalsdato til DB2 DATE;;DB2 DATE TIMESTAMP_FORMAT CAST' ,'201951*Easy lookup of data in PL/I;;INDEX PLI PL1 PL/I PL/1' ,'201949 CICS CPU forbrug igen igen (suk);;COBOL COLLECT SP DFHMNTDS TMRCPUT USRCPUT MIPS CPU' ,'201947*How to access the jobname of a job in an easy way;;JCL JOBNAME SYMBOLS' ,'201945 Wildcard matching i COBOL (simulering af SQL LIKE) - OPDATERET;;WILDCARD COBOL LIKE FILTER' ,'201943*SQL in DSNUPROC/DSNUTILB;;DB2 SQL UTILITY' ,'201941 SELECT X.* FROM i joins;;SELECT * SQL DB2' ,'201939*BIND option REOPT(ALWAYS) on statement level;;DB2 BIND REBIND QUERY FREE' ,'201937 Afstand mellem to timestamps;;TIMESTAMPDIFF SQL DB2' ,'201935*Picture strings;;ISPF EDIT VIEW FIND BROWSE CHANGE' ,'201933 Dagnumre i ISPF;;ISPF JULIAN DATE REXX' ,'201931*Running the same job again and again;;JCL SCHEDULE INTRDR SUBMIT' ,'201929 LOCATE kommandoen i SDSF system LOG display;;SDSF LOGSTREAM LOCATE' ,'201927*Line commands on ISPF member lists;;ISPF MEMLIST EDIT VIEW BROWSE' ,'201925 Friske SMF data i en fart;;SMF JCL LOGSTREAM SMARTEPOVER' ,'201923*Updates of a DB2 table;;SYSLGRNX SYSTABLESPACESTATS TIMESTAMP' ,'201921 Hurtigere SQL statements i REXX, også for INSERT/UPDATE/DELETE;;REXX SQL USING HOSTVARIABLE' ,'201919*Faster SQL statements in REXX;;REXX SQL USING HOSTVARIABLE' ,'201917 Brug af DB2 DSN-kommandoen fra REXX;;DB2 DSN PULL PUSH REXX' ,'201915*NOLOG on XMIT/TRANSMIT and LOGDATASET on RECEIVE;;XMIT TRANSMIT NOLOG RECEIVE LOGDATASET LOGDSNAME B37 X37' ,'201913 Frigør ubrugt plads i VSAM datasets;;ADRDSSU RELEASE DB2 STOP START' ,'201911*Last update of a DB2 table;;SYSLGRNX SYSTABLESPACESTATS TIMESTAMP' ,'201909 Nem datasøgning i PL/I;;INDEX PLI PL1 PL/I PL/1' ,'201907*Generating jobs using REXX;;REXX ISPF FT FILE TAILORING' ,'201905 Hvordan du nemt får fat i jobnavnet i et batchjob;;JCL JOBNAME SYMBOLS' ,'201903*Finding enqueues using your own program;;REXX ENQ ISPF' ,'201852 SQL i DSNUPROC/DSNUTILB;;DB2 SQL UTILITY' ,'201850*20 years anniversary/20 års jubilæum;;TIP LIST TIPLIST FØDSELSDAG BIRTHDAY OVERSIGT' ,'201848 BIND option REOPT(ALWAYS) på statement niveau;;DB2 BIND REBIND QUERY FREE' ,'201846*Using names in DB2 with all sorts of characters;;DB2 SQL AS' ,'201844 Picture strings;;ISPF EDIT VIEW FIND BROWSE CHANGE' ,'201842*ISPF EDIT/VIEW FIND using regular expressions;;ISPF EDIV VIEW FIND EXCLUDE CHANGE' ,'201840 Kørsel af det samme job igen og igen;;JCL SCHEDULE INTRDR SUBMIT' ,'201838*Transfer of datasets between different SYSPLEX;;JCL ROUTE XEQ XMIT TRANSMIT RECEIVE' ,'201836 Liniekommandoer på memberlister i ISPF;;ISPF MEMLIST EDIT VIEW BROWSE' ,'201834*Jobflows just using JCL;;JCL SCHEDULE JG JOBGROUP SDSF' ,'201832 Opdateringer af en DB2 tabel;;SYSLGRNX SYSTABLESPACESTATS TIMESTAMP' ,'201830*REBIND using APREUSE(WARN);;REBIND APREUSE DB2' ,'201828 Hurtigere SQL statements i REXX;;REXX SQL USING HOSTVARIABLE' ,'201826*Short timestamps;;DB2 SQL TIMESTAMP' ,'201824 NOLOG på XMIT/TRANSMIT og LOGDATASET på RECEIVE;;XMIT TRANSMIT NOLOG RECEIVE LOGDATASET LOGDSNAME B37 X37' ,'201822*Join of datasets;;SORT JCL JOIN' ,'201820 Sidste opdatering af en DB2 tabel;;SYSLGRNX SYSTABLESPACESTATS TIMESTAMP' ,'201818*Run your job at a predefined time;;JCL SCHEDULE STARTBY HOLDUNTL' ,'201816 Job generering med REXX;;REXX ISPF FT FILE TAILORING' ,'201814*Index on expressions;;DB2 IX CREATE INDEX' ,'201812 Find enqueues med dit eget program;;REXX ENQ ISPF' ,'201810*Clever use of the SORT command in ISPF EDIT/VIEW;;LABEL SORT ISPF EDIT VIEW .ZCSR .ZL' ,'201808 Navne i DB2 med alle mulige tegn;;DB2 SQL AS' ,'201806*Date calculations in REXX;;DATE TIME REXX' ,'201804 ISPF EDIT/VIEW FIND med regular expressions;;ISPF EDIV VIEW FIND EXCLUDE CHANGE' ,'201802*Simulating hostvariables in SPUFI and similar tools;;WITH SQL DB2' ,'201752 Overførsel af datasets mellem forskellige SYSPLEX;;JCL ROUTE XEQ XMIT TRANSMIT RECEIVE' ,'201750*Long-awaited options in SDSF;;SDSF DA JD JM JS ENQ' ,'201748 Jobflows kun med JCL;;JCL SCHEDULE JG JOBGROUP SDSF' ,'201746*EXPLAIN PACKAGE;;DB2 BIND REBIND VERSION COLLID COLLECTION' ,'201744 REBIND med APREUSE(WARN);;REBIND APREUSE DB2' ,'201742*Access to datasets;;RACF SR SEARCH' ,'201740 Korte timestamps;;DB2 SQL TIMESTAMP' ,'201738*Joining several rows into one row using SQL revisited;;RECURSIVE WITH SELECT UNION' ,'201736 Join af datasets;;SORT JCL JOIN' ,'201734*Easy help to make your own SDSF;;SDSF COLSHELP ISFCALLS ISFEXEC' ,'201732 Kør dit job på et bestemt tidspunkt;;JCL SCHEDULE STARTBY HOLDUNTL' ,'201730*SQLCODE -803 and duplicates;;DUPLICATE KEY RID SQL' ,'201728 Index on expressions;;DB2 IX CREATE INDEX' ,'201726*Sort order in ISPF EDIT/VIEW;;HEX SORT EDIT VIEW ISPF' ,'201724 Smart brug af SORT kommandoen i ISPF EDIT/VIEW;;LABEL SORT ISPF EDIT VIEW .ZCSR .ZL' ,'201722*Searching for character strings in SQL;;POSITION POSSTR DB2' ,'201720 Dato aritmetik i REXX;;DATE TIME REXX' ,'201718*The longest record in a VB dataset;;DFSORT VB JCL' ,'201716 Simulering af hostvariable i SPUFI og lignende;;WITH SQL DB2' ,'201714*Access to the ISPF screen buffer with screen width 132;;ISPF PANEL ZSCREENW ZSCREEND ZSCREENC ZSCREENI' ,'201712 Længe ventede muligheder i SDSF;;SDSF DA JD JM JS ENQ' ,'201710*REBIND without surprises;;REBIND APCOMPARE APREUSE DB2' ,'201708 EXPLAIN PACKAGE;;DB2 BIND REBIND VERSION COLLID COLLECTION' ,'201706*SORT can also do calculations;;DFSORT ADD MUL DIV MOD SUB' ,'201704 Adgang til datasets;;RACF SR SEARCH' ,'201702*Using DECODE instead of CASE in SQL;;CASE DECODE SQL DB2' ,'201652 At samle flere rækker sammen til een med SQL igen;;RECURSIVE WITH SELECT UNION' ,'201650*Fresh SMF data;;SMF JCL LOGSTREAM' ,'201648 Nem hjælp til at bygge din egen SDSF;;SDSF COLSHELP ISFCALLS ISFEXEC' ,'201646*LINK/BIND of LOAD-modules with DSNULI;;DB2 DSNELI DSNHLI DSNALI DSNCLI DSNRLI -922 -927' ,'201644 SQLCODE -803 og dubletter;;DUPLICATE KEY RID SQL' ,'201642*Easy repetition of ISPF EDIT/VIEW commands;;& ISPF EDIT VIEW COMMANDS PRIMARY' ,'201640 Sorteringsrækkefølge i ISPF EDIT/VIEW;;HEX SORT EDIT VIEW ISPF' ,'201638*Enqueue challenges using ISPF in batch;;ISPSTART ISPT036 ENQUEUE ISPPROF ISPSPROF' ,'201636 Søgning efter tegnstrenge med SQL;;POSITION POSSTR DB2' ,'201634*SQL MERGE statement performance;;DB2 SQL MERGE' ,'201632 Den længste record i et VB dataset;;DFSORT VB JCL' ,'201630*Wait a moment revisited;;WAIT DELAY SLEEP REXX COBOL' ,'201628 Adgang til ISPF skærmbufferen med 132 tegns bredde;;ISPF PANEL ZSCREENW ZSCREEND ZSCREENC ZSCREENI' ,'201626*SQL GROUP BY with sums and totals;;SQL DB2 ROLLUP CUBE' ,'201624 REBIND uden overraskelser;;REBIND APCOMPARE APREUSE DB2' ,'201622*Multi volume datasets;;UNIT VOLUME JCL B37' ,'201620 SORT nu også med aritmetik;;DFSORT ADD MUL DIV MOD SUB' ,'201618*Easy memberscan directly from ISPF member list;;ISPF SRCHFOR SEARCH FIND REFRESH SEARCHFOR' ,'201616 Brug af DECODE i stedet for CASE i SQL;;CASE DECODE SQL DB2' ,'201614*SELECT SQL statements in REXX to DB2;;REXX SQL DB2 DSNREXX' ,'201612 Friske SMF data;;SMF JCL LOGSTREAM' ,'201610*Non-SELECT SQL statements in REXX to DB2;;REXX SQL DB2 DSNREXX' ,'201608 LINK/BIND af LOAD-moduler med DSNULI;;DB2 DSNELI DSNHLI DSNALI DSNCLI DSNRLI -922 -927' ,'201606*Make your own SDSF;;REXX SDSF SYSVIEW PREFIX ISFCALLS' ,'201604 Nem gentagelse af ISPF EDIT/VIEW kommandoer;;& ISPF EDIT VIEW COMMANDS PRIMARY' ,'201602*JCL variable substitution in inline SYSIN;;JCL JOB SYSIN VARIABLE VARIABEL' ,'201553 Enqueue udfordringer med ISPF batch;;ISPSTART ISPT036 ENQUEUE ISPPROF ISPSPROF' ,'201551*Generation of increasing key values in SQL;;SQL SELECT INSERT SEQUENCE' ,'201549 SQL MERGE statement performance;;DB2 SQL MERGE' ,'201547*Validation of datatypes in REXX;;REXX DATATYPE SAY' ,'201545 Lige et øjeblik, igen;;WAIT DELAY SLEEP REXX COBOL' ,'201543*Completely hide excluded lines in ISPF EDIT/VIEW;;ISPF VIEW EDIT HIDE RESET' ,'201541 SQL GROUP BY med summer og totaler;;SQL DB2 ROLLUP CUBE' ,'201539*SQL GROUP BY without GROUP BY, but with sums and totals;;SQL DB2 OLAP GROUP BY PARTITION OVER ORDER' ,'201537 Multi volume datasets;;UNIT VOLUME JCL B37' ,'201535*Recursive calls in PL/I;;RECURSIVE CALL PLI PL/I PL1 PL/1' ,'201533 Nem søgning direkte fra ISPF memberliste;;ISPF SRCHFOR SEARCH FIND REFRESH SEARCHFOR' ,'201531*GROUP BY functionality on datasets;;SORT SUM DUPLICATES ICETOOL SELECT DFSORT' ,'201529 SELECT SQL statements i REXX mod DB2;;REXX SQL DB2 DSNREXX' ,'201527*SQL unpacking a decimal field hidden in a character string;;DB2 SQL DECIMAL FIXED COMP-3 HEX SUBSTR CAST' ,'201525 Ikke-SELECT SQL statements i REXX mod DB2;;REXX SQL DB2 DSNREXX' ,'201523*Recursive calls in COBOL;;RECURSIVE CALL PERFORM COBOL' ,'201521 Lav din egen SDSF;;REXX SDSF SYSVIEW PREFIX ISFCALLS' ,'201519*From ISPEXEC in REXX to ISPLINK in PLI;;REXX ISPLINK ISPEXEC PLI PL/I PL1 PL/1' ,'201517 JCL variabel substitution i inline SYSIN;;JCL JOB SYSIN VARIABLE VARIABEL' ,'201515*Converting SELECT into DELETE/UPDATE;;DB2 SQL QMF SPUFI' ,'201513 Stigende nøglegenerering i SQL;;SQL SELECT INSERT SEQUENCE' ,'201511*What CICS is doing right now;;CICS CEMT TASK' ,'201509 Validering af datatyper i REXX;;REXX DATATYPE SAY' ,'201507*A new kind of special registers in DB2 SQL;;DB2 SQL CURRENT GETVARIABLE' ,'201505 Gem excluded lines i ISPF EDIT/VIEW helt væk;;ISPF VIEW EDIT HIDE RESET' ,'201503*The mainframe is almost 51 years old;;IBM SYSTEM 360 370' ,'201501 SQL GROUP BY uden GROUP BY, men med summer og totaler;;SQL DB2 OLAP GROUP BY PARTITION OVER ORDER' ,'201451*The easiest way to terminate a PL/I program;;GOBACK STOP RETURN PLI PL1 PL/I PL/1 EXIT' ,'201449 Rekursive kald i PL/I;;RECURSIVE CALL PLI PL/I PL1 PL/1' ,'201447*Equal to and not equal to on the same column in static SQL;;SQL WHERE EQ NE' ,'201445 GROUP BY funktionalitet på datasets;;SORT SUM DUPLICATES ICETOOL SELECT DFSORT' ,'201443*Debugging of error situations in COBOL;;COBOL DEBUG XPEDITER GOBACK' ,'201441 SQL udpakning af decimal felt gemt i tegnstreng;;DB2 SQL DECIMAL FIXED COMP-3 HEX SUBSTR CAST' ,'201439*Authorisation to create indexes;;DB2 CREATE INDEX SYSRESAUTH SYSDBAUTH' ,'201437 Rekursive kald i COBOL;;RECURSIVE CALL PERFORM COBOL' ,'201435*Editing and browsing of datasets containing ASCII characters;;ISPF EDIT VIEW BROWSE SOURCE ASCII' ,'201433 Fra ISPEXEC i REXX til ISPLINK i PLI;;REXX ISPLINK ISPEXEC PLI PL/I PL1 PL/1' ,'201429*Authorisation to create tables;;DB2 CREATE TABLE SYSRESAUTH SYSDBAUTH' ,'201427 Fra SELECT til DELETE/UPDATE;;DB2 SQL QMF SPUFI' ,'201425*UNIX shell in TSO/ISPF;;UNIX TSO OMVS ISHELL LS ISPF' ,'201423 Hvad CICS laver lige nu;;CICS CEMT TASK' ,'201421*FTP between your PC and the mainframe;;FTP BAT' ,'201419 En ny slags special registers i DB2 SQL;;DB2 SQL CURRENT GETVARIABLE' ,'201417*Last time a program was executed;;DB2 SQL LOAD PACKAGE 10 V10' ,'201415 Mainframen fylder 50 år;;IBM SYSTEM 360 370' ,'201413*RACF-protection of your own datasets;;RACF TSO AD ADDSD DD DELDSD SR SEARCH LD LISTDSD' ,'201411 Den nemmeste afslutning af et PL/I program;;GOBACK STOP RETURN PLI PL1 PL/I PL/1 EXIT' ,'201409*When tablespacescan is better than index access;;DB2 PLAN_TABLE PREFETCH SEQUENTIAL' ,'201407 Forskellig fra og lig med på samme kolonne i statisk SQL;;SQL WHERE EQ NE' ,'201405*An alternative to NOT EXISTS in SQL;;UNION INTERSECT EXCEPT SQL' ,'201403 Debugging af fejlsituationer i COBOL;;COBOL DEBUG XPEDITER GOBACK' ,'201401*A simple scanner;;PLI PL1 PL/I PL/1 PARM' ,'201351 Adgang til at oprette index;;DB2 CREATE INDEX SYSRESAUTH SYSDBAUTH' ,'201349*Which RACF authorisation do you have to a dataset;;RACF RACROUTE ASM ASSEMBLER' ,'201347 Editering og browse af dataset med ASCII-tegn;;ISPF EDIT VIEW BROWSE SOURCE ASCII' ,'201345*Correct numbering of rows returned by SQL;;SQL DB2 SELECT OLAP NUMBER' ,'201343 Adgang til at oprette tabeller;;DB2 CREATE TABLE SYSRESAUTH SYSDBAUTH' ,'201341*Using DB2 to collect execution errors;;COMMIT ROLLBACK ERROR LOG LOGNING LOGGING' ,'201339 UNIX shell i TSO/ISPF;;UNIX TSO OMVS ISHELL LS ISPF' ,'201337*Your own variables in JCL;;JCL SET JOB VARIABLE VARIABEL' ,'201334 FTP mellem din PC og mainframen;;FTP BAT' ,'201332*SMF-record processing;;SMF PLI PL/I PL1 PL/1' ,'201327 Hvornår et program sidst blev eksekveret;;DB2 SQL LOAD PACKAGE 10 V10' ,'201325*Dynamic SQL statement CPU consumption and more;;EXPLAIN STMTCACHE ALL SQL DB2 STATEMENTCACHE DSN_STATEMENT_CACHE_TABLE CPU GETPAGE' ,'201323 RACF-beskyttelse af egne datasets;;RACF TSO AD ADDSD DD DELDSD SR SEARCH LD LISTDSD' ,'201321*Splitting records at specific words;;ISPF EDIT MACRO REXX TS TEXT SPLIT TEXTSPLIT TEKST TXT' ,'201319 Når tablespacescan er bedre end index access;;DB2 PLAN_TABLE PREFETCH SEQUENTIAL' ,'201316*Global areas in TSO or BATCH;;TSO ISPF LOAD ASSEMBLER STORAGE SHARED POOL' ,'201314 Et alternativ til NOT EXISTS i SQL;;UNION INTERSECT EXCEPT SQL' ,'201312*Extented search in MQM;;WEBSPHERE MQ MQM TSO' ,'201310 En simpel scanner;;PLI PL1 PL/I PL/1 PARM' ,'201308*Joining several rows into one row using SQL;;SQL SELECT LEFT JOIN RIGHT JOIN OUTER JOIN' ,'201306 Hvilken RACF adgang du har til et dataset;;RACF RACROUTE ASM ASSEMBLER' ,'201304*SDSF in batch;;SDSF JCL' ,'201302*Status after the first 14 years;;TIP LINKEDIN' ,'201301 Status efter de første 14 år;;TIP LINKEDIN' ,'201251 Rigtige numre på rækker returneret i SQL;;SQL DB2 SELECT OLAP NUMBER' ,'201250*Validation of numeric data in DB2 using SQL;;TRANSLATE SQL DB2 NUMERIC' ,'201249*Conversion of binary and packed fields to readable numbers using DFSORT;;JCL SORT ICEMAN BI PD ZD TO PACKED BINARY DECIMAL INTEGER COMP' ,'201248 Brug af DB2 til opsamling af programfejl;;COMMIT ROLLBACK ERROR LOG LOGNING LOGGING' ,'201247*Calculation of weeknumber in REXX;;REXX WEEK DATE WEEKNO' ,'201246*Predefined OPC variables;;OPC TIVOLI JCL JOB WORKLOAD SCHEDULER SCAN' ,'201245 Dine egne variable i JCL;;JCL SET JOB VARIABLE VARIABEL' ,'201244*Performance optimized usage of SYSDUMMY1 on z/OS;;SYSDUMMY1 SYSIBM PRUNED SQL DB2' ,'201243*Long strings in PL/I;;STRING PLI PL1 PL/I PL/1 CHAR' ,'201241 Behandling af SMF-records;;SMF PLI PL/I PL1 PL/1' ,'201240*JCL procedures;;JCL JES2 PROC JCLLIB' ,'201239*Your own TIMESTAMP function without using DB2;;TIMESTAMP STCKE ASM ASSEMBLER' ,'201238 Dynamisk SQL statement CPU forbrug med mere;;EXPLAIN STMTCACHE ALL SQL DB2 STATEMENTCACHE DSN_STATEMENT_CACHE_TABLE CPU GETPAGE' ,'201237*Virtual indexes in DB2;;VIRTUAL INDEX DSN_VIRTUAL_INDEXES EXPLAIN SQL' ,'201236*PL/I value lists in IF statements;;IF SELECT PLI PL/I PL1 PL/1' ,'201235 Opsplitning af records ved udvalgte ord;;ISPF EDIT MACRO REXX TS TEXT SPLIT TEXTSPLIT TEKST TXT' ,'201234*SQL tuning of WHERE;;OPTIMIZER SQL WHERE INDEX ONLY' ,'201231*Submit a job to another JES system;;JES2 ROUTE XEQ JCL' ,'201229 Globale arealer i TSO eller BATCH;;TSO ISPF LOAD ASSEMBLER STORAGE SHARED POOL' ,'201228*Dynamic SQL, EXPLAIN and the statement cache;;EXPLAIN STMTCACHE ALL SQL DB2 STATEMENTCACHE DSN_STATEMENT_CACHE_TABLE' ,'201227*Inline REXX in JCL;;REXX JCL JOB TSO VARIABEL VARIABLE SYSIN' ,'201226 Udvidede søgninger i MQM;;WEBSPHERE MQ MQM TSO' ,'201225*Access to the ISPF screen buffer;;ISPF PANEL ZSCREENW ZSCREEND ZSCREENC ZSCREENI' ,'201224*Finding dataset name connected to a DD name;;SWA TOKEN SWATOKEN SWA-TOKEN TIOT JFCB DEB' ,'201223 At slå flere rækker sammen til een med SQL;;SQL SELECT LEFT JOIN RIGHT JOIN OUTER JOIN' ,'201222*Using time to control COMMIT frequency;;SQL DB2 COMMIT CURRENT TIMESTAMP GENERATE_UNIQUE' ,'201221*Implicit declaration of variables in PL/I;;PL/I PLI PL1 PL/1 DECLARE DCL' ,'201220 SDSF i batch;;SDSF JCL' ,'201219*Inline REXX in ISPF panels;;REXX ISPF PANEL )BODY )INIT )REINIT' ,'201218*Transfer of parameters in PL/I;;PL/I PLI PL1 PL/1 CALL' ,'201217 Validering af numeriske data i DB2 med SQL;;TRANSLATE SQL DB2 NUMERIC' ,'201216*SELECT now also available with UPDATE and DELETE;;SELECT UPDATE DELETE SQL DB2' ,'201214*Editing many members in a dataset;;SORT DFSORT ICEMAN JCL IEBPTPCH IEBUPDTE IFTHEN BUILD' ,'201213 Konvertering af binære og pakkede felter til læsbare tal med DFSORT;;JCL SORT ICEMAN BI PD ZD TO PACKED BINARY DECIMAL INTEGER COMP' ,'201212*SQLCODE -904;;DISPLAY DB SPACE RESTRICT DATABASE START' ,'201211*The ISPF command DDLIST and more about enqueues;;ISRDDN DDLIST ENQ ISPF' ,'201210 Beregning af ugenummer i REXX;;REXX UGE WEEK DATE UGENR WEEKNO' ,'201209*USERID in COBOL and PL/I;;USER USERID COBOL PLI PL1 PL/I PL/1' ,'201208*Recursive SQL in DB2;;SQL DB2 RECURSIVE WITH SELECT UNION' ,'201207 Predefinerede OPC-variable;;OPC TIVOLI JCL JOB WORKLOAD SCHEDULER SCAN' ,'201206*Calculating sums in ISPF EDIT/VIEW;;ISPF EDIT VIEW REXX MACRO EDITMACRO' ,'201205*CICS CPU usage revisited;;COBOL COLLECT SP DFHMNTDS TMRCPUT USRCPUT MIPS CPU' ,'201204 Performance optimeret brug af SYSDUMMY1 på z/OS;;SYSDUMMY1 SYSIBM PRUNED SQL DB2' ,'201203*Showing shared CICS TS-queue information using CEMT;;CICS CEMT TSQ CEBR POOL TSM' ,'201202*MQ information in a MQ group;;MQM SHARING QUEUE MANAGER' ,'201201 Lange tegnstrenge i PL/I;;STRING PLI PL1 PL/I PL/1 CHAR' ,'201151*Numbering of returned rows from SQL statement;;SQL SEQUENCE DB2 SELECT' ,'201150*Redefinition of COBOL SYSOUT;;SYSOUT COBOL PROCESS CBL OUTDD' ,'201149 JCL procedurer;;JCL JES2 PROC JCLLIB' ,'201148*Controlling function keys in ISPF panels;;ISPF PANEL ISPPLIB ZCMD KEYS ZPF VPUT F-keys' ,'201147*Like in SQL and CHAR columns;;LIKE SQL STRIP' ,'201146 Din egen TIMESTAMP funktion uden at bruge DB2;;TIMESTAMP STCKE ASM ASSEMBLER' ,'201145*Easy allocation of DB2-datasets;;DB2 PRIQTY SECQTY -1' ,'201144*Buffering of data while reading a file;;COBOL JCL BUFFER' ,'201142 Virtuelle indekser i DB2;;VIRTUAL INDEX DSN_VIRTUAL_INDEXES EXPLAIN SQL' ,'201141*ISPF VDEFINE and VDELETE;;VDEFINE VDELETE ISPF COBOL PLI PL1 PL/I PL/1' ,'201140*Creator for table names in SQL statements;;SCHEMA CREATOR OWNER SQL DB2' ,'201139 PL/I værdi-lister i IF-sætninger;;IF SELECT PLI PL/I PL1 PL/1' ,'201138*Compound assignments in PL/I;;PLI PL1 PL/I PL/1 = += -= *= /= !!= ||=' ,'201137*Processing of data in an EDIT macro;;REXX EDIT MACRO EDITMACRO ISPF' ,'201136 SQL tuning af WHERE;;OPTIMIZER SQL WHERE INDEX ONLY' ,'201135*Job output from executing jobs;;SDSF SYSVIEW DA ST SYSNAME ESYS JOBSUM ACTIVITY MVS SYSPLEX' ,'201134*Controlling joins in DB2;;DB2 SQL OPTIMIZER JOIN INDEX JOINS SELECT EXPLAIN' ,'201133 Submit af job til andet JES-system;;JES2 ROUTE XEQ JCL' ,'201132*Easy CICS screen dialogue;;CICS RECEIVE SEND TEXT' ,'201129*Readable DB2 data on the mainframe;;SQL DB2 CAST CHAR ASCII EBCDIC UNICODE SBCS MIXED' ,'201126 Dynamisk SQL, EXPLAIN og statement cache;;EXPLAIN STMTCACHE ALL SQL DB2 STATEMENTCACHE DSN_STATEMENT_CACHE_TABLE' ,'201125*Readable ASCII files in ISPF;;ASCII EBCDIC UTF8 UNICODE ISPF BROWSE DISPLAY' ,'201124*LOAD REPLACE in tablespaces with many tables;;DELETE EXEC SQL LOAD DB2 REPLACE' ,'201123 Inline REXX i JCL;;REXX JCL JOB TSO VARIABEL VARIABLE SYSIN' ,'201122*Editing large datasets;;TSO ISPF EDIT VIEW LOGON' ,'201121*DB2 real time statistics;;DB2 SYSTABLESPACESTATS SYSINDEXSPACESTATS SYSIBM' ,'201120 Adgang til ISPF skærmbufferen;;ISPF PANEL ZSCREENW ZSCREEND ZSCREENC ZSCREENI' ,'201119*Conversion to hexadecimal values;;SQL PLI PL/1 PL1 PL/I REXX COBOL HEX HEXIMAGE ASM ASSEMBLER' ,'201118*Splitting column into more than one row;;DB2 SQL SELECT SUBSTR' ,'201117 Find datasetnavn ud fra DD navn;;SWA TOKEN SWATOKEN SWA-TOKEN TIOT JFCB DEB' ,'201116*MQ response times;;MQ MQPUT MQPUT1 MQGET MQMD MESSAGE DESCRIPTOR PUTDATE PUTTIME 2033' ,'201115*Who is using my member;;ENQ ENQUEUES MEMBER DATASET REPLACE CONTENTION' ,'201114 Styring af COMMIT på tid;;SQL DB2 COMMIT CURRENT TIMESTAMP GENERATE_UNIQUE' ,'201113*The ISPF EDIT/VIEW command COLS;;ISPF EDIT VIEW COLS' ,'201112*Easy search using DSLIST;;ISPF 3.4 DSLIST SF SEARCHFOR SEARCH FOR FIND' ,'201111 Implicit erklæring af variable i PL/I;;PL/I PLI PL1 PL/1 DECLARE DCL' ,'201110*Conditions in COBOL;;COBOL IF OR AND NOT UNTIL' ,'201109*Different sort criterias in the same SELECT;;DB2 SQL SELECT ORDER BY CASE' ,'201108 Inline REXX i ISPF-paneler;;REXX ISPF PANEL )BODY )INIT )REINIT' ,'201107*Removing trailing characters in PL/I;;PLI PL1 PL/1 PL/I TRIM STRIP RTRIM BLANKE' ,'201106*LISTCAT functionality in COBOL;;CSI COBOL DSLIST LISTCAT' ,'201105 Parameteroverførsel i PL/I;;PL/I PLI PL1 PL/1 CALL' ,'201104*Conditional execution of subselect;;CASE SQL DB2' ,'201103*EDIT/VIEW line command definition in PF-KEYS;;ISPF EDIT VIEW KEYS' ,'201102 SELECT nu også med UPDATE og DELETE;;SELECT UPDATE DELETE SQL DB2' ,'201101*Initialization of COBOL working-storage;;CANCEL COBOL CALL' ,'201051*Indentations using the CHANGE command in ISPF EDIT;;EDIT VIEW CHANGE C ISPF' ,'201050 Editering af mange members i et dataset;;SORT DFSORT ICEMAN JCL IEBPTPCH IEBUPDTE IFTHEN BUILD' ,'201049*SELECT with INSERT;;SELECT INSERT SQL DB2' ,'201048*Improved changing of data in DFSORT;;SORT DFSORT ICEMAN JCL OUTREC INREC OUTFIL' ,'201047 SQLCODE -904;;DISPLAY DB SPACE RESTRICT DATABASE START' ,'201046*The SUM function in SQL;;SQL DB2 SUM CASE' ,'201045*MQ connect and disconnect;;MQCONN MQDISC 2002 MQS' ,'201044 ISPF-kommandoen DDLIST og mere om enqueues;;ISRDDN DDLIST ENQ ISPF' ,'201043*Using INSPECT in COBOL like INDEX in PL/I, POS in REXX and POSSTR in SQL;;INSPECT COBOL INDEX POS POSSTR' ,'201041*Set your own returncode from ISPF;;ZISPFRC RC ISPF VPUT VREPLACE ISPLINK PLI PL1 PL/I PL/1' ,'201040 USERID i COBOL og PL/I;;USER USERID COBOL PLI PL1 PL/I PL/1' ,'201039*ISPF and DB2 in batch;;TSO ISPF DB2 JCL DSN RUN CP' ,'201038*Triggers on MQ queues in CICS;;CICS MQ MQM INITQ' ,'201037 Rekursiv SQL i DB2;;SQL DB2 RECURSIVE WITH SELECT UNION' ,'201036*Date and timestamp usage in WHERE clauses in DB2;;TRUNC TIMESTAMP DATE ROUND TRUNC_TIMESTAMP ROUND_TIMESTAMP SQL' ,'201035*PL/I simulation of COBOL working-storage;;PLI PL/I PL1 PL/1 COBOL CONTROLLED CTL' ,'201034 Beregn summer i ISPF EDIT/VIEW;;ISPF EDIT VIEW REXX MACRO EDITMACRO' ,'201033*The CICS parameter runaway time;;CICS CEMT CEDA LOOP AICA SUSPEND' ,'201032*Optimization of subselects for versioning in DB2 version 8;;SUB SELECT SUBSELECT SUB-SELECT FETCH FIRST ROW ONLY ORDER BY SQL DB2 VERSION 8' ,'201031 CICS CPU forbrug igen;;COBOL COLLECT SP DFHMNTDS TMRCPUT USRCPUT MIPS CPU' ,'201030*Dynamic call of programs from a COBOL program;;DYNAM NODYNAM COBOL CICS TSO LOAD' ,'201027*Character conversion in MQ;;MQGMO_CONVERT MQGMO-CONVERT MQGET GET MESSAGE OPTIONS' ,'201026 At vise shared CICS TS-køer med CEMT;;CICS CEMT TSQ CEBR POOL TSM' ,'201025*Removing trailing blanks in DB2;;DB2 STRIP RTRIM INSERT' ,'201024*Getting around FIND limit;;FIND LIMIT ALL SDSF SYSVIEW' ,'201023 MQ oplysninger i en MQ gruppe;;MQM SHARING QUEUE MANAGER' ,'201022*SS line command in SYSVIEW;;STEP JOB JCL STEP SUMMARY JOB SUMMARY' ,'201021*SQLCODE -911;;SQLCA ROLLBACK DB2 -913' ,'201020 Numre på rækker returneret i SQL;;SQL SEQUENCE DB2 SELECT' ,'201019*List of members in a PDS;;TSO LISTDS PO DATASET' ,'201018*The contents of ISPF Z-variables;;ISPF Z PROFILE POOL SHARED POOL' ,'201017 Redefiner COBOL SYSOUT;;SYSOUT COBOL PROCESS CBL OUTDD' ,'201016*The REXX function DATE;;DATE REXX JULIAN SAY' ,'201015*Backout of MQ messages;;MQ BACKOUTCOUNT SYNCPOINT MQBACK MQCMIT HARDEN' ,'201014 Styring af PF-taster i ISPF-paneler;;ISPF PANEL ISPPLIB ZCMD KEYS ZPF VPUT F-taster' ,'201013*PARM= in JCL and Language Environment;;LE NOEXECOPS COBOL PLI PL/I PL/1 PL1' ,'201012*CICS CPU usage;;COBOL COLLECT SP DFHMNTDS TMRCPUT USRCPUT MIPS CPU' ,'201011 Like i SQL og CHAR kolonner;;LIKE SQL STRIP' ,'201010*The INSERT function in SQL;;SQL INSERT' ,'201009*RETURN statement in COBOL;;COBOL RETURN NEXT SENTENCE GO TO GOTO GOBACK' ,'201007 Nem allokering af DB2-spaces;;DB2 PRIQTY SECQTY -1' ,'201006*DB2 cross-loader;;INSERT SELECT EXEC SQL LOAD DB2 CROSS LOADER' ,'201005*Command for copying of datasets and members;;TSO IDCAMS REPRO JCL' ,'201004 Buffering af data ved læsning af fil;;COBOL JCL BUFFER' ,'201003*CICS TS queue administration;;CICS CEMT TSQ CEBR' ,'201002*CUT and PASTE in ISPF EDIT and VIEW;;ISPF EDIT VIEW CUT PASTE CLIPBOARD DATASPACE' ,'201001 ISPF VDEFINE og VDELETE;;VDEFINE VDELETE ISPF COBOL PLI PL1 PL/I PL/1' ,'200952*Specifying compiler options;;PROCESS CBL COBOL PLI PL1 PL/I PL/1' ,'200951*Varying DD names in COBOL;;COBOL DD' ,'200950 Creator på tabel-navne i SQL-kald;;SCHEMA CREATOR OWNER SQL DB2' ,'200949*NULLS in the WHERE clause;;SQL DB2 OUTER JOIN WHERE NULLS' ,'200948*Shared CICS TS queues;;CICS READQ TS WRITEQ CECI CEMT' ,'200947 Compound assignments i PL/I;;PLI PL1 PL/I PL/1 = += -= *= /= !!= ||=' ,'200946*Automatic cleanup of MQ messages;;MQ EXPIRY MQMD MQGET MQPUT MQPUT1' ,'200945*Execution of DB2 commands from PL/I;;PLI PL1 PL/I PL/1 DB2 IFI CAF DSNWLI' ,'200944 Behandling af data med EDIT macro;;REXX EDIT MACRO EDITMACRO ISPF' ,'200942*Wait a moment;;WAIT DELAY SLEEP ILBOWAT0 REXX COBOL PL/I PLI PL/1 PL1 CICS' ,'200941*SQLCODE -905 and DB2 Governor;;DB2 RLF Resource Limit Facility DSNRLST' ,'200940 Job output fra eksekverende jobs;;SDSF SYSVIEW DA ST SYSNAME ESYS JOBSUM ACTIVITY MVS SYSPLEX' ,'200939*Find information with CEMT;;CICS CEMT PROG TASK FILE TRANS DB2E DB2C DB2T' ,'200938*Name of the dead letter queue and other MQ information;;MQ MQM TSO PLI PL1 PL/1 PL/I' ,'200937 Styr på join i DB2;;DB2 SQL OPTIMIZER JOIN INDEX JOINS SELECT EXPLAIN' ,'200936*Timestamps in PDSE LOAD modules;;LOAD DATO JULIAN DATE AMBLIST JCL HEX LINKAGE' ,'200935*How to find the location of a LOAD module;;ISRDDN LOAD LPA PLPA MLPA LINKLIST LLA APF LNK' ,'200934 Nem CICS skærmdialog;;CICS RECEIVE SEND TEXT' ,'200933*UNICODE trouble in DB2 version 8 and later;;SUBSTRING SQL UNICODE DB2' ,'200930*Is your MVS system under stress?;;MVS SDSF CPU% LCPU SYSVIEW' ,'200929 Læsbare DB2 data på mainframen;;SQL DB2 CAST CHAR ASCII EBCDIC UNICODE SBCS MIXED' ,'200928*DD names allocated to your job;;DD ALLOCATE TIOT JCL COBOL ISRDDN PLI PL/I PL/1 PL1' ,'200927*The TSO command CALL;;CALL TSO STEPLIB LINKLIST' ,'200926 Læsbare ASCII filer i ISPF;;ASCII EBCDIC UTF8 UNICODE ISPF BROWSE DISPLAY' ,'200925*Timestamps and unique keys in DB2;;GENERATE_UNIQUE TIMESTAMP SQL DB2' ,'200924*The MVS catalog;;LISTCAT CATALOG ALIAS UCAT USERCATALOG' ,'200923 LOAD REPLACE i tablespaces med mange tabeller;;DELETE EXEC SQL LOAD DB2 REPLACE' ,'200922*CPU usage;;COBOL PSA ASCB MIPS CPU' ,'200921*When DB2 joins may use an index;;DB2 INDEX INDICES PREDICATES CONDITIONS JOINS' ,'200920 Editering af store datasets;;TSO ISPF EDIT VIEW LOGON' ,'200919*Transforming a flat file into a PDS;;IEBUPDTE JCL' ,'200918*The COND parameter in JCL;;COND RC JCL EXEC JOB' ,'200917 DB2 real time statistics;;DB2 SYSTABLESPACESTATS SYSINDEXSPACESTATS SYSIBM' ,'200915*SQLCODE -805;;BIND TIMESTAMP DBRM LMOD LOADMODUL PACKAGE PLAN DB2' ,'200914*Transforming a PDS into a flat file;;IEBPTPCH JCL' ,'200913 Konvertering til hexadecimale værdier;;SQL PLI PL/1 PL1 PL/I REXX COBOL HEX HEXIMAGE ASM ASSEMBLER' ,'200912*REBIND of packages;;DB2 BIND REBIND COPY COLLECTION EXPLAIN ACCESS' ,'200911*Left justifying numeric values in COBOL;;COBOL UNSTRING PIC' ,'200910 Dele kolonne over flere rækker;;DB2 SQL SELECT SUBSTR' ,'200909*Dataset name(s) for your DB2 table;;DB2 SQL VSAM LDS CASE STRIP TABLESPACE' ,'200908*REXX calling REXX from TSO;;REXX SYSPROC SYSEXEC TSO ISPF' ,'200907 MQ svartider;;MQ MQPUT MQPUT1 MQGET MQMD MESSAGE DESCRIPTOR PUTDATE PUTTIME 2033' ,'200906*Number of records in a dataset;;VSAM DFSORT IEBGENER ICEGENER ICEMAN' ,'200905*Variable groups in the SQL where clause;;DB2 SQL ROW VALUE EXPRESSION WHERE' ,'200904 Hvem bruger mit member;;ENQ ENQUEUES MEMBER DATASET REPLACE CONTENTION' ,'200903*Standard JCL variables;;JCL SYSUID NOTIFY JES2 JES3' ,'200902*DB2 subsystems on my MVS;;DB2 ERLY SSCT' ,'200852 ISPF EDIT/VIEW kommandoen COLS;;ISPF EDIT VIEW COLS' ,'200851*True global variables across any programming language;;COBOL PLI PL1 PL/I PL/1 REXX ASSEMBLER ASM IEANT' ,'200850 10 års jubilæum/10 years anniversary;;UGENS TIP WEEKLY TIP' ,'200849*Tuning of assignment statements;;MOVE = COBOL PLI PL1 PL/I PL/1 SUBSTR' ,'200848 Nem søgning med DSLIST;;ISPF 3.4 DSLIST SF SEARCHFOR SEARCH FOR FIND SRCHFOR' ,'200847*DB2 functions in programs;;DB2 SQL SYSDUMMY1 SYSIBM SET' ,'200846*Using TSO commands without using TSO;;TSO IKJEFT01 TSOENV TSOLNK' ,'200845 Betingelser i COBOL;;COBOL IF OR AND NOT UNTIL' ,'200841*Using ISPF EDIT in QMF;;QMF EDIT QUERY RUN PROC MESSAGE ISPF EDIT REXX' ,'200840*More HSM information;;MCDS HLIST ISRDDN ENQ HRECALL HMIGRATE SORT' ,'200839 Forskellige sort-kriterier i samme SELECT;;DB2 SQL SELECT ORDER BY CASE' ,'200838*OUTER JOIN in SQL instead of IF in program;;DB2 SQL LEFT RIGHT OUTER JOIN IF' ,'200837*The JCL parameter RESTART;;JCL RESTART STEP JOB JES2 JES3' ,'200836 At fjerne efterstillede tegn i PL/I;;PLI PL1 PL/1 PL/I TRIM STRIP RTRIM BLANKE' ,'200835*The existence of a dataset;;DSLIST 3.4 PLI PL1 PL/1 PL/I REXX CSI CATALOG SYSDSN LISTCAT' ,'200834*Making your own CHANGE program using PL/I;;PLI PL1 PL/1 PL/I UPDATE' ,'200833 LISTCAT funktionalitet fra COBOL;;CSI COBOL DSLIST LISTCAT' ,'200832*Simple restart on output dataset;;DB2 RENAME ALLOC COMMIT IMS DISP MOD' ,'200829*Changing DB2 subsystem using CAF;;CAF PLI PL1 PL/I PL/1 DB2 CONNECT DISCONNECT OPEN CLOSE' ,'200828 Betinget eksekvering af subselect;;CASE SQL DB2' ,'200827*Writing spanned records from COBOL;;VB 32760 VBS COBOL AFP SMF' ,'200826*DSLIST line command II;;REXX ISPF DSLIST TSO LISTCAT VSAM' ,'200825 EDIT/VIEW linie-kommandoer i PF-taster;;ISPF EDIT VIEW KEYS' ,'200824*The REXX command PARSE SOURCE;;REXX PARSE SOURCE TSO ISPF SYSEXEC SYSPROC' ,'200823*Copying rows within the same DB2 table;;INSERT INTO SELECT * FROM SQL DB2 GENERATE_UNIQUE' ,'200822 Initialisering af COBOL working-storage;;CANCEL COBOL CALL' ,'200821*Return codes from MQ COMMAND in batch;;MQ RC MQM MQS CSQUTIL MAKEDEF COMMAND' ,'200820*Updating REXX variables from COBOL;;REXX COBOL IRXEXCOM' ,'200819 Indrykninger med CHANGE kommandoen i ISPF EDIT;;EDIT VIEW CHANGE C ISPF' ,'200818*Limiting the number of rows returned by DB2;;DB2 SQL FETCH FIRST ROWS ONLY ORDER BY' ,'200817*Avoiding character translation when using FTP;;FTP ASCII EBCDIC MODE TYPE BINARY BLOCK STREAM RECORD STRUCT FILE' ,'200816 SELECT nu også med INSERT;;SELECT INSERT SQL DB2' ,'200815*EXTERNAL data structures in COBOL;;COBOL EXTERNAL' ,'200814*Comparing fields in datasets;;ICETOOL DISTINCT DUPLICATES COMPARE' ,'200813 Forbedrede ændringer af data i DFSORT;;SORT DFSORT ICEMAN JCL OUTREC INREC OUTFIL' ,'200811*The DB2 table SYSIBM.SYSCOPY;;ICTYPE SYSIBM SYSCOPY DB2 MODIFY IC IMAGECOPY' ,'200810*DISPLAY in COBOL;;COBOL DISPLAY SYSOUT SYSPUNCH CONSOLE CICS' ,'200809 SUM-funktionen i SQL;;SQL DB2 SUM CASE' ,'200808*Date formats in DB2;;SQL DB2 CHAR DATE ISO EUR USA JIS LOCAL' ,'200807*Browsing storage with REXX;;REXX STORAGE D2X C2D' ,'200806 MQ connect og disconnect;;MQCONN MQDISC 2002 MQS' ,'200805*Batch or online;;PLI PL1 PL/I PL/1 COBOL JES2 TSO CICS STC' ,'200804*Creating your own commands in QMF;;QMF SQL RESET QUERY RUN PROC MESSAGE' ,'200803 Brugen af INSPECT i COBOL som INDEX i PL/I, POS i REXX og POSSTR i SQL;;INSPECT COBOL INDEX POS POSSTR' ,'200802*The CICS MQ monitor transaction CKQC;;MQ MQM CICS CKQC' ,'200801 Bestem selv returkoden fra ISPF;;ZISPFRC RC ISPF VPUT VREPLACE ISPLINK PLI PL1 PL/I PL/1' ,'200751*SMS-compression again;;SMS COMPRESSION COMPACTION GENERIC TAILORED GEN TCOM' ,'200750 ISPF og DB2 i batch;;TSO ISPF DB2 JCL DSN RUN CP' ,'200749*Create your own SUBMIT command;;INTRDR TSO REXX JCL' ,'200748 Triggere på MQ-køer i CICS;;CICS MQ MQM INITQ' ,'200747*ALTER of SECQTY on tablespaces and indexes;;SECQTY ALTER SQL DB2 LISTCAT' ,'200746 Dato og timestamp opslag i DB2;;TRUNC TIMESTAMP DATE ROUND TRUNC_TIMESTAMP ROUND_TIMESTAMP SQL' ,'200745*FTP cond codes in batch;;FTP EXIT COND CODE RC' ,'200744 PL/I simulering af COBOL working-storage;;PLI PL/I PL1 PL/1 COBOL CONTROLLED CTL' ,'200743*TSO/REXX command EXECIO;;TSO REXX EXECIO ADDRESS STEM' ,'200742 CICS parameteren runaway time;;CICS CEMT CEDA LOOP AICA SUSPEND' ,'200741*Comparing the content of two DB2 tables;;DB2 SQL UNION' ,'200740 Optimering af subselects til versionering i DB2 version 8;;SUB SELECT SUBSELECT SUB-SELECT FETCH FIRST ROW ONLY ORDER BY SQL DB2 VERSION 8' ,'200739*Submitting jobs for parallel execution;;JCL JES TSO SUBMIT' ,'200738 Dynamisk kald af programmer fra et COBOL-program;;DYNAM NODYNAM COBOL CICS TSO LOAD' ,'200737*IBM mainframe abbreviations;;messageid DB2 DSN CICS DFH TSO IKJ ISPF PLI IBM REXX IRX SMS DGT TLA MQS CSQ EQQ OPC DSQ QMF ISF SDSF JES2 IEF' ,'200736 Tegnkonvertering i MQ;;MQGMO_CONVERT MQGMO-CONVERT MQGET GET MESSAGE OPTIONS' ,'200735*ISPF EDIT command COMP (compare);;ISPF VIEW EDIT COMP COMPARE MD MAKE DATA' ,'200734 At fjerne efterstillede blanke i DB2;;DB2 STRIP RTRIM INSERT' ,'200733*Segmented tablespaces;;DB2 SEGSIZE CREATE TABLESPACE DELETE FROM' ,'200732 Omgåelse af FIND limit;;FIND LIMIT ALL SDSF SYSVIEW' ,'200731*A simple calculator;;REXX INTERPRET HEX D2X X2D SAY' ,'200728 SS linie-kommandoen i SYSVIEW;;STEP JOB JCL STEP SUMMARY JOB SUMMARY' ,'200727*The difference between correlated and noncorrelated subselects;;SQL SUB SELECT SUB-SELECT SUBSELECT' ,'200726 SQLCODE -911;;SQLCA ROLLBACK DB2 -913' ,'200725*Execution of TSO batch programs;;TSO PARM STEPLIB TSOLNK JCL' ,'200724 Liste over members i et PDS;;TSO LISTDS PO DATASET' ,'200723*OPTIMIZE FOR n ROWS in SQL statements;;DB2 OPTIMIZER SQL SQLCODE -905' ,'200722 Indholdet af ISPF Z-variable;;ISPF Z PROFILE POOL SHARED POOL' ,'200721*TSO commands in COBOL and PL/1;;TSO COBOL PL/1 PL1 PLI PL/I TSOLNK' ,'200720 REXX funktionen DATE;;DATE REXX JULIAN SAY' ,'200719*A trip with FTP;;TSO FTP' ,'200718 Backout af MQ messages;;MQ BACKOUTCOUNT SYNCPOINT MQBACK MQCMIT HARDEN' ,'200717*SQL function VALUE (COALESCE);;DB2 SQL IFNULL MIN MAX AVG SUM' ,'200716 PARM= i JCL og Language Environment;;LE NOEXECOPS COBOL PLI PL/I PL/1 PL1' ,'200714*Comparisons in REXX;;REXX == << >>' ,'200713 CICS CPU forbrug;;COBOL COLLECT SP DFHMNTDS TMRCPUT USRCPUT MIPS CPU' ,'200712*Optimizing your OUTER JOINS;;DB2 SQL LEFT RIGHT OUTER OUTTER JOIN VALUE' ,'200711 INSERT funktionen i SQL;;SQL INSERT' ,'200710*Your own TSO command processor;;TSO ISPF MACRO EDIT VIEW SELECT CMD REXX' ,'200709 RETURN statement i COBOL;;COBOL RETURN NEXT SENTENCE GO TO GOTO GOBACK' ,'200708*Using EXISTS in SQL;;SQL EXISTS INDEX ONLY' ,'200707 DB2 cross-loader;;INSERT SELECT EXEC SQL LOAD DB2 CROSS LOADER' ,'200706*More about deleting datasets;;EQQDELDS JCL NEW CATLG IDCAMS OPC' ,'200705 Kommando til kopiering af datasets og members;;TSO IDCAMS REPRO JCL' ,'200704*ISPF EDIT commands COPY, CREATE and REPLACE;;ISPF VIEW EDIT COPY CREATE REPLACE' ,'200703 CICS TS kø administration;;CICS CEMT TSQ CEBR' ,'200702*Minimising the timeout risk when performing a DB2 INSERT;;DB2 SQL INSERT SELECT UNIQUE WITH UR' ,'200701 CUT og PASTE i ISPF EDIT og VIEW;;ISPF EDIT VIEW CUT PASTE CLIPBOARD DATASPACE' ,'200651*Varying DD names in PL/1;;PLI PL1 PL/I TITLE DD' ,'200650 Angivelse af compiler options;;PROCESS CBL COBOL PLI PL1 PL/I PL/1' ,'200649*Reasonable use of ISPF KEYLIST;;ISPF KEYLIST TABLE ISPTABL ISPTLIB PANEL KEYS KEYLISTS' ,'200648 Variable DD navne i COBOL;;COBOL DD' ,'200647*Validation using a DB2 trigger;;DB2 TRIGGER SQLCA SYSTRIGGERS SYSIBM SIGNAL SQLSTATE' ,'200646 NULLS i WHERE betingelser;;SQL DB2 OUTER JOIN WHERE NULLS' ,'200645*Messages from ISPF services;;ISPF SETMSG ZERRMSG REXX CONTROL ERRORS CANCEL RETURN' ,'200644 Shared CICS TS køer;;CICS READQ TS WRITEQ CECI CEMT' ,'200643*Correlated subselects for versioning;;SQL SYSCOPY DB2 MIN MAX' ,'200642 Automatisk oprydning i MQ messages;;MQ EXPIRY MQMD MQGET MQPUT MQPUT1' ,'200641*Faster EDIT macroes;;EDIT MACRO EDITMACRO ISPF COBOL REXX CLIST' ,'200640 Eksekvering af DB2-kommandoer fra PL/1;;PLI PL1 PL/I PL/1 DB2 IFI CAF DSNWLI' ,'200639*Assignment of DCB informations in PL/1;;PLI PL1 PL/I PL/1 LRECL BLKSIZE RECFM' ,'200638 Vent et øjeblik;;WAIT DELAY SLEEP ILBOWAT0 REXX COBOL PL/I PLI PL/1 PL1 CICS' ,'200637*Problems using newcopy in CICS;;CICS CECI CEMT RELEASE ABEND' ,'200636 SQLCODE -905 og DB2 Governor;;DB2 RLF Resource Limit Facility DSNRLST' ,'200635*Names of DB2 subsystems using data sharing;;DB2 DIS GROUP REXX' ,'200634 Find oplysninger med CEMT;;CICS CEMT PROG TASK FILE TRANS DB2E DB2C DB2T' ,'200633*Dataset delete;;IDCAMS JCL DELETE' ,'200632 Navnet på dead letter køen og andre MQ oplysninger;;MQ MQM TSO PLI PL1 PL/1 PL/I' ,'200631*Reuse of a DB2 image copy;;DB2 IMAGE COPY DSN1COPY SYSCOPY DBID PSID OBID' ,'200628 Datostempling i PDSE LOAD-moduler;;LOAD DATO JULIAN DATE AMBLIST JCL HEX LINKAGE' ,'200627*TRANSMIT and RECEIVE of PO datasets;;TRANSMIT RECEIVE XMIT TSO' ,'200626 Migrering til DB2 version 8;;DB2 DIS GROUP DETAIL MODE V8' ,'200625*Smarter global temporary tables in DB2;;DB2 SQL CREATE TABLE INSERT SELECT DECLARE' ,'200624 Hvordan man kan finde et LOAD-modul;;ISRDDN LOAD LPA PLPA MLPA LINKLIST LLA APF LNK' ,'200623*Enlargement of a concatenation with one more dataset;;TSO ISPF REXX ALLOC LISTALC STATUS' ,'200622 Er din MVS belastet?;;MVS SDSF CPU% LCPU SYSVIEW' ,'200621*Avoid SAVE of data in ISPF EDIT;;ISPF EDIT END SAVE AUTOSAVE DEFINE NOP CANCEL' ,'200620 UNICODE ballade i DB2 version 8;;SUBSTRING SQL V8 UNICODE DB2' ,'200619*The LIBDEF function in ISPF;;ISPF LIBDEF COND STACK SELECT PASSLIB ISPLIBD' ,'200618 DD-navne allokeret til dit job;;DD ALLOCATE TIOT JCL COBOL ISRDDN PLI PL/I PL/1 PL1' ,'200617*Calling LOAD modules from REXX;;REXX LOAD LINK LINKPGM LINKMVS ATTACH ATTACHPGM ATTACHMVS PLI PL/1 PL1 COBOL VAG ASM ASSEMBLER C MQ' ,'200616 TSO kommandoen CALL;;CALL TSO STEPLIB LINKLIST' ,'200615*Spaces in SQL;;SPACES RTRIM LIKE SQL VARCHAR DB2 BLANKS' ,'200614 Timestamps og entydige nøgler i DB2;;GENERATE_UNIQUE TIMESTAMP SQL DB2' ,'200613*Record splitting using SORT;;SORT DFSORT OUTREC OUTFIL / SQL' ,'200612 MVS kataloget;;LISTCAT CATALOG ALIAS UCAT USERCATALOG' ,'200611*Informations in HSM;;HLIST TSO TRAP HSM MIGRATE BACKUP BCDS MCDS' ,'200610 CPU forbrug;;COBOL PSA ASCB MIPS CPU' ,'200609*SQL statements with joins, GROUP BY and HAVING;;SQL GROUP BY HAVING NESTED TABLE EXPRESSION JOIN' ,'200608 Pludselig opstået sygdom;;' ,'200607*More SMS compression;;SMS COMPRESSION COMPRESSED JCL DATACLAS EXTENT XMIT ADRDSSU' ,'200606 Hvornår DB2 joins kan anvende et index;;DB2 INDEX INDEKS PREDICATES PRÆDIKATER BETINGELSER JOINS' ,'200605*Generic searches in ISPF;;ISPF EDIT VIEW PICTURE FIND CHANGE' ,'200604 Omform en flad fil til et PDS;;IEBUPDTE JCL IEBUPDTE' ,'200603*Join of columns with different definitions;;DB2 SQL SELECT INSERT' ,'200602 COND parameteren i JCL;;COND RC JCL EXEC JOB' ,'200601*Please help me out of this;;Q X Z BYE EXIT END QUIT LOGOFF STOP RETURN GOBACK LEAVE CANCEL RCL' ,'200551 SQLCODE -805;;BIND TIMESTAMP DBRM LMOD LOADMODUL PACKAGE PLAN DB2' ,'200550*The TRANSLATE function in REXX and PL/1;;PL/1 PL/I PLI PL1 REXX ASM ASSEMBLER' ,'200549 Omform et PDS til en flad fil;;IEBPTPCH JCL' ,'200548*Calling CICS programs from batch or TSO;;EXCI CICS LINK' ,'200547 REBIND af packages;;DB2 BIND REBIND COPY COLLECTION EXPLAIN ACCESS' ,'200546*Testing return codes in batch TSO;;TSO IKJEFT01 WHEN' ,'200545 Venstrestilling af numeriske værdier i COBOL;;COBOL UNSTRING PIC' ,'200544*-DIS UTIL and DIAGNOSE DISPLAY SYSUTIL;;DIS UTIL DIAGNOSE DISPLAY SYSUTIL DB2 DSNUTILB' ,'200543 Datsetnavn(e) til DB2-tabel;;DB2 SQL VSAM LDS CASE STRIP TABLESPACE' ,'200542*A job step that always gets executed;;JES2 JCL COND CODE IF ENDIF RUN ABEND EVEN' ,'200541 REXX kalder REXX i TSO;;REXX SYSPROC SYSEXEC TSO ISPF' ,'200540*Who is using my MQ queue;;MQ MQS MQM TSO' ,'200539 Antal records i et dataset;;VSAM DFSORT IEBGENER ICEGENER ICEMAN' ,'200538*Global temporary tables in DB2;;DB2 SQL CREATE TABLE INSERT SELECT' ,'200537 Variabelgrupper i SQL where delen;;DB2 SQL ROW VALUE EXPRESSION WHERE' ,'200536*Start BookManager using your own bookshelf;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'200535 Standard JCL-variable;;JCL SYSUID NOTIFY JES2 JES3' ,'200534*Dataset copying using ISPF;;ISPF MOVE COPY 3.3 CREATE REPLACE' ,'200533 DB2 subsystemer på min MVS;;DB2 ERLY SSCT' ,'200529*IBM mainframe wildcards;;ISPF CICS DFDSS ADRDSSU CATALOG HSM DB2 SQL' ,'200528 Globale variable på tværs af hvad som helst;;COBOL PLI PL1 PL/I PL/1 REXX ASSEMBLER ASM IEANT' ,'200527*Options SORTKEYS, SORTDEVT and SORTNUM for DB2 LOAD/REORG;;SORTKEYS SORTDEVT SORTNUM LOAD REORG DB2' ,'200526 Tuning af assignment statements;;MOVE = COBOL PLI PL1 PL/I PL/1 SUBSTR' ,'200525*Making your own HSM backup;;HSM HBACKDS HRECOVER HLIST' ,'200524 DB2 funktioner i programmer;;DB2 SQL SYSDUMMY1 SYSIBM SET' ,'200523*Adjusting Dataset List defaults;;ISPF DSLIST 3.4' ,'200522 Brug TSO kommandoer uden om TSO;;TSO IKJEFT01 TSOENV TSOLNK' ,'200521*The FIND ALL command;;FIND ALL ISPF EDIT SDSF VIEW BROWSE' ,'200520 Normal ISPF EDIT i QMF;;QMF EDIT QUERY RUN PROC MESSAGE ISPF EDIT REXX' ,'200519*The HSM command TSO HSEND Q ACT;;HSEND Q ACT WAIT' ,'200518 Simpel restart på output dataset;;DB2 RENAME ALLOC COMMIT IMS DISP MOD' ,'200517*Making your own enqueue/dequeue mechanism in DB2;;DB2 SQL UPDATE LOCKS' ,'200516 Skift DB2 subsystem med CAF;;CAF PLI PL1 PL/I PL/1 DB2 CONNECT DISCONNECT OPEN CLOSE' ,'200515*Writing to a local queue on another MQ subsystem;;MQ REPLYTOQ REPLYTOQMGR' ,'200514 Skrivning af spanned records i COBOL;;VB 32760 VBS COBOL AFP SMF' ,'200512*Optimizing the SELECT list in SQL statements;;DB2 SQL SELECT' ,'200511 DSLIST liniekommandoen II;;REXX ISPF DSLIST TSO LISTCAT VSAM' ,'200510*Controlling your COBOL modules using DD cards;;DD DUMMY COBOL' ,'200509 REXX kommandoen PARSE SOURCE;;REXX PARSE SOURCE TSO ISPF SYSEXEC SYSPROC' ,'200508*Making less MQ remote queue definitions;;MQS MQ REPLYTOQ REPLYTOQMGR' ,'200507 Kopiering af rækker i samme DB2-tabel;;INSERT INTO SELECT * FROM SQL DB2' ,'200506*Remove leading blanks using PL/1;;PLI PL1 PL/1 PL/I' ,'200505 Returkoder fra MQ COMMAND i batch;;MQ RC MQM MQS CSQUTIL MAKEDEF COMMAND' ,'200504*CICS In-Storage tables;;CICS LOAD PROGRAM HOLD GETMAIN' ,'200503 Opdatering af REXX-variable fra COBOL;;REXX COBOL IRXEXCOM' ,'200502*Making your MQ definitions in batch;;MQS MQ CSQUTIL MAKEDEF DISPLAY' ,'200453 Hent kun de første n rækker i DB2;;DB2 SQL FETCH FIRST ROWS ONLY ORDER BY' ,'200452*IN lists in SQL statements;;DB2 SQL IN' ,'200451 At undgå tegnkonvertering med FTP;;FTP ASCII EBCDIC MODE TYPE BINARY BLOCK STREAM RECORD STRUCT FILE' ,'200450*ISPF EDIT command HEX;;ISPF EDIT HEX' ,'200449 EXTERNAL datastrukturer i COBOL;;COBOL EXTERNAL' ,'200448*Accessing main storage with PL/1;;PLI PL/1 PL1 PL/I ADDRESS POINTER STORAGE MVS CVT PSA' ,'200447 Sammenligning af felter i datasets;;ICETOOL DISTINCT DUPLICATES DUPLIKATER COMPARE' ,'200446*Line commands for ISPF Edit macros;;REXX EDIT MACRO EDITMACRO ISPF' ,'200445 DB2-tabellen SYSIBM.SYSCOPY;;ICTYPE SYSIBM SYSCOPY DB2 MODIFY IC IMAGECOPY' ,'200444*Object oriented PL/1;;PLI PL1 PL/1 PL/I OO OBJECT CONTROLLED' ,'200443 DISPLAY i COBOL;;COBOL DISPLAY SYSOUT SYSPUNCH CONSOLE CICS' ,'200442*SELECT * FROM table;;SQL SELECT DB2 QMF SPUFI DSNTEP2 FILE-AID FILEAID ACCESS' ,'200441 Dato-formater i DB2;;SQL DB2 CHAR DATE ISO EUR USA JIS LOCAL' ,'200440*DISTINCT used with UNION or UNION ALL;;SQL DISTINCT UNION ALL DB2' ,'200439 Kig i storage med REXX;;REXX STORAGE D2X C2D' ,'200438*Using SYSOUT=* to display dataset contens;;JCL SYSOUT' ,'200437 Batch eller online;;PLI PL1 PL/I PL/1 COBOL JES2 TSO CICS STC' ,'200436*CURRENT SQLID;;DB2 SQL' ,'200435 Lav dine egne kommandoer i QMF;;QMF SQL RESET QUERY RUN PROC MESSAGE' ,'200434*Install of CICS definitions without using CEDA;;CICS CEDA DFHEDAP' ,'200433 CICS MQ monitor transaktionen CKQC;;MQ MQM CICS CKQC' ,'200432*User friendly BookManager;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'200431 Smartere global temporary tables i DB2;;DB2 SQL CREATE TABLE INSERT SELECT DECLARE' ,'200429 Ugens tip holder sommerferie / The weekly tip is on summer holidays;;' ,'200428*Returning bad SQLCODE when SELECTing zero rows;;SQL DB2 CASE SELECT DSNTIAUL DSNTEP2' ,'200427 Udvid en concatenering med et ekstra dataset;;TSO ISPF REXX ALLOC LISTALC STATUS' ,'200426*Dynamic call of programs from PL/1;;PLI PL1 PL/1 PL/I ASSEMBLER ASM' ,'200425 Undgå SAVE af data i ISPF EDIT;;ISPF EDIT END SAVE AUTOSAVE DEFINE NOP CANCEL' ,'200424*Fallback of DB2 plans/packages;;ISPF EDIT END SAVE AUTOSAVE DEFINE NOP CANCEL' ,'200423 LIBDEF funktionen i ISPF;;ISPF LIBDEF COND STACK SELECT PASSLIB ISPLIBD' ,'200422*The OPC RECOVER function;;OPC RECOVER RESTART JCL' ,'200421 Kald af LOAD-moduler fra REXX;;REXX LOAD LINK LINKPGM LINKMVS ATTACH ATTACHPGM ATTACHMVS PLI PL/1 PL1 COBOL VAG ASM ASSEMBLER C MQ' ,'200420*WORK datasets for ISPF;;ISPCTL0 VIO SPFTEMP0 FILE-TAILORING FTOPEN TEMP' ,'200419 Blanke i SQL;;SPACES RTRIM LIKE SQL VARCHAR DB2' ,'200418*Selfdocumenting REXX programs;;REXX SOURCELINE' ,'200417 Opsplitning af records med SORT;;SORT DFSORT OUTREC OUTFIL / SQL' ,'200416*SMS dataset compression;;SMS COMPRESSION COMPRESSED JCL DATACLAS ISMF' ,'200415 Flere HSM informationer;;MCDS HLIST ISRDDN ENQ HRECALL HMIGRATE SORT' ,'200414*The DISCARD option on DB2 REORG;;DISCARD REORG DB2 NOPAD COMPRESSED' ,'200413 OUTER JOIN i SQL i stedet for IF i program;;DB2 SQL LEFT RIGHT OUTER JOIN IF' ,'200412*The ISPF EDIT command BNDS;;ISPF EDIT VIEW BNDS BOUNDS' ,'200411 JCL-parameteren RESTART;;JCL RESTART STEP JOB JES2 JES3' ,'200410*The TSO command PROFILE;;TSO PROFILE NOPREFIX NOMSGID NOINTERCOM PREFIX MSGID INTERCOM' ,'200409 Lav dit eget CHANGE program med PL/1;;PLI PL1 PL/1 PL/I UPDATE' ,'200408*Dirty reads in SQL statements;;WITH UR SQL FOR FETCH ONLY' ,'200407 Ugens tip holder fri / The weekly tip is on vacation;;' ,'200406 At finde et dataset;;DSLIST 3.4 PLI PL1 PL/1 PL/I REXX CSI CATALOG SYSDSN LISTCAT' ,'200405*Command SE in SDSF and JCL parameter SCHENV;;SDSF JCL SCHENV SHEDULING ENVIRONMENT SYSAFF JOBPARM' ,'200404 Informationer i HSM;;HLIST TSO TRAP HSM MIGRATE BACKUP BCDS MCDS' ,'200403*Executing DFSORT using the DSN processor;;SORT DFSORT ICEMAN JCL DB2 DSN' ,'200402 SQL-kald med joins, GROUP BY og HAVING;;SQL GROUP BY HAVING NESTED TABLE EXPRESSION JOIN' ,'200401 Godt nytår / Happy new year;;' ,'200352*Deleting all rows in a DB2 table;;DB2 LOAD SQL REUSE NOCOPYPEND' ,'200351 SMS-compression igen;;SMS COMPRESSION COMPACTION GENERIC TAILORED GEN TCOM' ,'200350*Issuing ISPF messages from REXX;;ISPF REXX' ,'200349 Lav din egen SUBMIT kommando;;INTRDR TSO REXX JCL' ,'200348*The order of predicates in SQL;;SQL DB2 HIGH2KEY LOW2KEY' ,'200347 MXI: alt om MVS;;MXI MVS MXIMVS' ,'200346*Hypertext with ISPF Edit/View;;ISPF EDIT VIEW KEYS MACRO EDITMACRO REXX' ,'200345 ALTER af SECQTY på tablespaces og indexes;;SECQTY ALTER SQL DB2 LISTCAT' ,'200344*Deletion of members;;ISPF JCL IDCAMS IEHPROGM' ,'200343 FTP returkoder i batch;;FTP EXIT COND CODE RC' ,'200342*Index-screening in DB2;;DB2 SQL' ,'200341 TSO/REXX kommandoen EXECIO;;TSO REXX EXECIO ADDRESS STEM' ,'200340*Changing data using File-Aid/Batch;;FILE-AID FILEAID JCL' ,'200339 Sammenlign indholdet af to DB2-tabeller;;DB2 SQL UNION' ,'200338*Executing other SQL statements than SELECT using DSNTIAUL;;DB2 SQL DSNTIAUL' ,'200337 Submit af jobs til eksekvering i parallel;;JCL JES TSO SUBMIT' ,'200336*Changing your data using DFSORT;;SORT DFSORT ICEMAN JCL' ,'200335 IBM mainframe forkortelser;;messageid DB2 DSN CICS DFH TSO IKJ ISPF PLI IBM REXX IRX SMS DGT TBF MQS CSQ EQQ OPC DSQ QMF ISF SDSF JES2 IEF' ,'200334*Speeding up deletion of rows in DB2 tables;;DB2 SQL LOCKPART' ,'200333 ISPF EDIT kommandoen COMP (compare);;ISPF VIEW EDIT COMP COMPARE MD MAKE DATA' ,'200332*Read any file using PL/1;;PL/1 PLI PL1' ,'200330 Segmented tablespaces;;DB2 SEGSIZE CREATE TABLESPACE DELETE FROM' ,'200329*Row level locking in DB2;;DB2 LOCK LOCKSIZE LOCKMAX NUMLKTS' ,'200328 En simpel lommeregner;;REXX INTERPRET HEX D2X X2D SAY' ,'200327*Trapping of screen output from TSO commands;;TRAP TSO REXX ISPF ISPEXEC' ,'200326 Forskellen på correlated og non-correlated subselects;;SQL SELECT SUB-SELECT' ,'200325*Allocation of DB2-spaces;;DB2 PRIQTY SECQTY TRACK CYLINDER TRKS CYLS VSAM' ,'200324 Eksekvering af TSO batch programmer;;TSO PARM STEPLIB TSOLNK JCL' ,'200323*Using % in front of TSO commands;;TSO REXX CLIST SYSEXEC SYSPROC LOAD' ,'200322 OPTIMIZE FOR n ROWS i SQL-kald;;DB2 OPTIMIZER SQL SQLCODE -905' ,'200321*Showing the contens of an ISPF-table;;REXX ISPF ISPEXEC TSO' ,'200320 TSO-kommandoer i COBOL og PL/1;;TSO COBOL PL/1 PL1 PLI TSOLNK' ,'200319*Disabling Abend-Aid in batch;;ABEND AID DUMP SYSUDUMP JCL' ,'200318 Ud at se med FTP;;TSO FTP' ,'200316*Optimization of calls to VAG from COBOL programs;;CSP VAG COBOL' ,'200315 SQL-funktionen VALUE (COALESCE);;DB2 SQL IFNULL MIN MAX AVG SUM' ,'200314*Finding rows in DB2 table with the same key;;SQL GROUP BY HAVING NESTED TABLE' ,'200313 Sammenligninger i REXX;;REXX == << >>' ,'200312*Concatenation on DD *;;JCL DD SYSIN SYSTSIN' ,'200311 Optimering af OUTER JOINS;;DB2 SQL LEFT RIGHT OUTER OUTTER JOIN VALUE' ,'200310*DB2 trace facilities: DSN-command and CAF;;DB2 CAF TRACE DSN DSNTRACE TSO SQL' ,'200309 Din egen TSO command processor;;TSO ISPF MACRO EDIT VIEW SELECT CMD REXX' ,'200308*Asynchronous tasks in CICS: DELAY;;CICS START CANCEL DELAY REQID ICE' ,'200307 Brugen af EXISTS i SQL;;SQL EXISTS INDEX ONLY' ,'200306*Asynchronous tasks in CICS: START and CANCEL;;CICS START CANCEL TRANSID REQID ICE' ,'200305 Mere sletning af datasets;;EQQDELDS JCL NEW CATLG IDCAMS OPC' ,'200304*ISPF EDIT labels .ZF and .ZL;;ISPF .ZF .ZFIRST .ZL .ZLAST .ZCSR FIND CHANGE EDIT SORT' ,'200303 ISPF EDIT kommandoerne COPY, CREATE og REPLACE;;ISPF VIEW EDIT COPY CREATE REPLACE' ,'200302*Display Active (DA) in SDSF of many MVS-systems;;SDSF DA SYSNAME PREFIX CATALOG SYSPLEX' ,'200251 Minimering af timeout-risikoen på DB2 INSERT;;DB2 SQL INSERT SELECT UNIQUE WITH UR' ,'200250*Communicate with another CICS from your CICS;;CICS CESF CRTE CONN' ,'200249 Variable DD-navne i PL/1;;PLI PL1 TITLE DD' ,'200248*Cheating the DB2-optimizer with an IN-list;;SQL DB2 IN' ,'200247 Nyttig brug af ISPF KEYLIST;;ISPF KEYLIST TABLE ISPTABL ISPTLIB PANEL KEYS KEYLISTS' ,'200246*Special validations in ISPF panels;;ISPF TRUNC .TRAIL' ,'200245 Validering med en DB2 trigger;;DB2 TRIGGER SQLCA SYSTRIGGERS SYSIBM SIGNAL SQLSTATE' ,'200244*DB2 CAF interface;;DB2 CAF' ,'200243 Messages fra ISPF services;;ISPF SETMSG ZERRMSG REXX CONTROL ERRORS CANCEL RETURN' ,'200242*Names for variables in REXX;;REXX' ,'200241 Correlated subselects til versionering;;SQL SYSCOPY DB2 MIN MAX' ,'200240*Errorhandling in CICS;;CICS HANDLE NOHANDLE EIBRESP' ,'200239 Hurtigere EDIT macroer;;EDIT MACRO EDITMACRO ISPF COBOL REXX CLIST' ,'200238*DB2 REORG UNLOAD EXTERNAL;;DB2 REORG UNLOAD EXTERNAL JCL LOAD' ,'200237 Tildeling af DCB-oplysninger i PL/1;;PLI PL1 LRECL BLKSIZE RECFM' ,'200236*Dynamic allocation of REXX-libraries;;REXX TSO ALTLIB EXECUTIL CLIST SYSEXEC SYSPROC' ,'200235 Problemer med newcopy i CICS;;CICS CECI CEMT RELEASE ABEND' ,'200234*Generating ready-to-use SYSIN with DB2;;DB2 SQL DSNTIAUL UNLOAD JCL SUBSTR' ,'200233 Navne på DB2 subsystemer med data sharing;;DB2 DIS GROUP REXX' ,'200232*Using ? in DB2 SQL EXPLAIN statements;;DB2 SQL EXPLAIN ?' ,'200229 Sletning af datasets;;IDCAMS JCL DELETE' ,'200228*Copying the same line to different places with ISPF EDIT;;REXX EDIT MACRO EDITMACRO FIND ISPF' ,'200227 TRANSMIT og RECEIVE af PO-datasets;;TRANSMIT RECEIVE XMIT TSO' ,'200226*ISPF log dataset;;ISPF LOG LIST' ,'200225 Genbrug af DB2 image copy;;DB2 IMAGE COPY DSN1COPY SYSCOPY DBID PSID OBID' ,'200224*Accessing main storage with COBOL;;COBOL ADDRESS SET POINTER STORAGE MVS CVT PSA' ,'200223 Mere SMS-compression;;SMS COMPRESSION COMPRESSED JCL DATACLAS EXTENT XMIT ADRDSSU' ,'200222*Restore of HSM backups;;TSO HSM BACKUP RESTORE HLIST RECOVER HRECOVER' ,'200221 Generiske søgninger i ISPF;;ISPF EDIT VIEW PICTURE FIND CHANGE' ,'200220*A fast DB2 reorg;;DB2 ADRDSSU DFDSS REORG EXTENTS' ,'200219 Join af kolonner med forskellige definitioner;;DB2 SQL SELECT INSERT' ,'200218*CICS-programs in status REQ;;CICS LINK LOAD XCTL CEMT PGMIDERR DFHRPL PPT' ,'200217 Hjælp, jeg vil ud af det her;;Q X Z BYE EXIT END QUIT LOGOFF STOP RETURN GOBACK LEAVE CANCEL RCL' ,'200216*The ISPF command RETP;;ISPF RETP RETRIEVE' ,'200215 TRANSLATE funktionen i REXX og PL/1;;PL/1 PL/I PLI PL1 REXX ASM ASSEMBLER' ,'200213*Setting return code to 0 in TSO batch;;JCL TSO BATCH RC0 IEFBR14' ,'200212 Kald af CICS-programmer fra batch eller TSO;;EXCI CICS LINK' ,'200211*GROUP BY on expressions in SQL;;SQL GROUP BY EXPRESSION DB2 NESTED TABLE SUBSELECT' ,'200210 Test på returkoder i TSO batch;;TSO IKJEFT01 WHEN' ,'200209*Who is using my dataset;;ENQ ENQUEUE GRS ISPF 3.4 DSLIST' ,'200208 -DIS UTIL og DIAGNOSE DISPLAY SYSUTIL;;DIS UTIL DIAGNOSE DISPLAY SYSUTIL DB2 DSNUTILB' ,'200207*The SQL CASE expression;;DB2 SQL CASE' ,'200206 Et job-step, der altid bliver eksekveret;;JES2 JCL COND CODE IF ENDIF RUN ABEND EVEN' ,'200205*Finding informations about COBOL abends;;COBOL ABEND CICS CEBR SYSABOUT 1037 CEMT' ,'200204 Hvem bruger min MQ-kø;;MQ MQS MQM TSO' ,'200203*Browse and Edit of DB2 tables;;DB2 FILEAID FILE-AID ACCESS CLIST REXX F2XNTRFC F2XNSAMP' ,'200202 Global temporary tables i DB2;;DB2 SQL CREATE TABLE INSERT SELECT' ,'200152*Giving other users access to your datasets;;RACF PE PERMIT ACCESS ALTER UPDATE LD' ,'200151 Start BookManager med din egen bookshelf;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'200150*The PROJECT, GROUP and TYPE fields in ISPF;;ISPF PROJECT GROUP TYPE TSO' ,'200149 Kopiering af datasets med ISPF;;ISPF MOVE COPY 3.3' ,'200148*Making your own bookshelf in BookManager;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'200147 IBM mainframe wildcards;;ISPF CICS DFDSS ADRDSSU CATALOG HSM DB2 SQL' ,'200146*An ISPF-command trick;;ISPF REXX EDIT MACRO EDITMACRO TRANSLATE' ,'200145 SORTKEYS, SORTDEVT og SORTNUM options på DB2 LOAD/REORG;;SORTKEYS SORTDEVT SORTNUM LOAD REORG DB2' ,'200144*The table with exactly one row;;SQL DB2 SYSDUMMY1 SPUFI CURRENT TIMESTAMP' ,'200143 Lav din egen HSM backup;;HSM HBACKDS HRECOVER HLIST' ,'200142*Internal tables in REXX;;REXX TABLE STEM' ,'200141 Justering af Dataset List defaults;;ISPF DSLIST 3.4' ,'200140*Establishing the existance of a row using SQL;;DB2 SQL EXISTS CURSOR UPDATE -811' ,'200139 Kommandoen FIND ALL;;FIND ALL ISPF EDIT SDSF VIEW BROWSE' ,'200138*The MAX-RC column in SDSF;;SDSF MAX-RC RC CC CONDCODE STATUS ST' ,'200137 HSM kommandoen TSO HSEND Q ACT;;HSEND Q ACT WAIT' ,'200136*The CUT-function in the 3270-emulator;;3270 CUT ERASE' ,'200135 Lav din egen enqueue/dequeue mekanisme i DB2;;DB2 SQL UPDATE LOCKS' ,'200134*Crossreferences between DB2-tables and programs;;DB2 SQL TABLE PROGRAM PACKAGE PLAN SYSPACKAGE SYSPLAN SYSTABAUTH' ,'200133 Skriv direkte til lokal-køen på en anden MQ;;MQS MQ REPLYTOQ REPLYTOQMGR' ,'200132*Syncronizing jobs with DISP=OLD;;JCL DISP DISP=OLD OLD DISP=MOD MOD' ,'200131 Optimering af SELECT-listen i SQL-kald;;DB2 SQL SELECT' ,'200128*UNLOAD your DB2-data with DSNTIAUL;;DB2 SQL JCL DSNTIAUL UNLOAD LOAD' ,'200127 Styr dine COBOL-moduler med DD-kort;;DD DUMMY COBOL' ,'200126*LOAD module timestamp;;LOAD DATE AMBLIST JCL HEX LINKAGE' ,'200125 Spar på dine MQ remote-kø definitioner;;MQS MQ REPLYTOQ REPLYTOQMGR' ,'200124*ISPF tool ISRDDN with enqueues;;ISPF ISRDDN ENQ ENQUEUE' ,'200123 Fjern foranstillede blanke med PL/1;;PLI PL1 PL/1' ,'200122*Easy copying of datasets;;ADRDSSU COPY DFDSS' ,'200121 Storage-tabeller i CICS;;CICS LOAD PROGRAM HOLD GETMAIN' ,'200120*Finding data inconsistency using SQL;;DB2 SQL INCONSISTENCY OUTER OUTTER JOIN INNER EXISTS' ,'200119 Lav din egen MQS-definition;;MQS MQ CSQUTIL MAKEDEF DISPLAY' ,'200118*Some useful SDSF commands;;SDSF XDC SJ SE //' ,'200117 IN-lister i SQL-kald;;DB2 SQL IN' ,'200115*When a dataset runs out of space;;DATASET EXTENT EXTENTS ADRDSSU DFDSS' ,'200114 ISPF EDIT kommandoen HEX;;ISPF EDIT HEX' ,'200113*Useful RACF commands;;RACF TSO LU LG LD' ,'200112 Kig i storage med PL/1;;PLI PL/1 PL1 ADDRESS POINTER STORAGE MVS CVT PSA' ,'200111*TSO command HQ;;HSM HQ HQUERY' ,'200110 Linie-kommandoer til ISPF Edit macroer;;REXX EDIT MACRO EDITMACRO ISPF' ,'200109*ISPF View command REPLACE;;ISPF EDIT VIEW REPLACE' ,'200108 Mere objekt-orienteret PL/1;;PLI PL1 PL/1 OO OBJECT CONTROLLED' ,'200107*Conversion of CHAR and VARCHAR to DECIMAL using SQL;;DB2 SQL CHAR VARCHAR DECIMAL INTEGER NUMBER' ,'200106 SELECT * FROM tabel;;SQL SELECT DB2 QMF SPUFI DSNTEP2 FILE-AID FILEAID ACCESS' ,'200105*Use of SPACE parameter with existing datasets;;JCL SPACE' ,'200104 Brug af DISTINCT sammen med UNION og UNION ALL;;SQL DISTINCT UNION ALL DB2' ,'200103*ISPF Edit line-commands L and F;;ISPF EDIT F FIRST L LAST' ,'200102 Brug af SYSOUT=* til at se dataset-indhold;;JCL SYSOUT' ,'200101*ISPF Edit macro ONLY;;ISPF EDIT ONLY ISRONLY FIND EXCLUDE' ,'200051 CURRENT SQLID;;DB2 SQL' ,'200050 Install af CICS-definitioner uden CEDA;;CICS CEDA DFHEDAP' ,'200049 Mere brugervenlighed i BookManager;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'200048 Dynamisk kald af programmer fra et PL/1-program;;PLI PL1 PL/1 PL/I ASSEMBLER ASM' ,'200047 Fallback af DB2-planer/packages;;DB2 PLAN PACKAGE BIND DBRM' ,'200046 RECOVER funktionen i OPC;;OPC RECOVER RESTART JCL' ,'200045 Negativ SQL-kode fra SELECT, der returnerer 0 rækker;;SQL DB2 CASE SELECT' ,'200043 WORK-dataset til ISPF;;ISPCTL0 VIO SPFTEMP0 FILE-TAILORING FTOPEN TEMP' ,'200042 Selvdokumenterende REXX-programmer;;REXX SOURCELINE' ,'200041 SMS-compression af datasets;;SMS COMPRESSION COMPRESSED JCL DATACLAS ISMF' ,'200040 DISCARD option på DB2 REORG;;DISCARD REORG DB2 NOPAD COMPRESSED' ,'200039 ISPF EDIT kommandoen BNDS;;ISPF EDIT BNDS BOUNDS' ,'200038 TSO-kommandoen PROFILE;;TSO PROFILE NOPREFIX NOMSGID NOINTERCOM PREFIX MSGID INTERCOM' ,'200037 Dirty reads i SQL-kald;;WITH UR SQL FOR FETCH ONLY' ,'200036 SE-kommandoen i SDSF og JCL-parameteren SCHENV;;SDSF JCL SCHENV SHEDULING ENVIRONMENT SYSAFF JOBPARM' ,'200035 DFSORT-eksekvering med DSN-processoren;;SORT DFSORT ICEMAN JCL DB2 DSN' ,'200034 Sletning af alle rækker i DB2-tabel;;DB2 LOAD SQL' ,'200033 ISPF messages i REXX;;ISPF REXX' ,'200031 Betingelsernes orden i SQL;;SQL DB2 HIGH2KEY LOW2KEY' ,'200030 Hypertext med ISPF Edit/View;;ISPF EDIT VIEW KEYS MACRO EDITMACRO REXX' ,'200029 Sletning af members;;ISPF JCL IDCAMS IEHPROGM' ,'200028 Index-screening i DB2;;DB2 SQL' ,'200027 File-Aid/Batch til ændring af data;;FILE-AID FILEAID JCL' ,'200025 Udsted andre SQL-kald end SELECT med DSNTIAUL;;DB2 SQL DSNTIAUL' ,'200024 Ændring af data med DFSORT;;SORT DFSORT ICEMAN JCL' ,'200023 Mere fart på sletning af rækker i DB2;;DB2 SQL LOCKPART' ,'200022 Læsning af filer med PL/1;;PL/1 PLI PL1' ,'200021 Row-level locking i DB2;;DB2 LOCK LOCKSIZE LOCKMAX NUMLKTS' ,'200020 "Trapping" af skærm-output fra TSO-kommandoer;;TRAP TSO REXX ISPF ISPEXEC' ,'200019 Allokering af DB2-spaces;;DB2 PRIQTY SECQTY TRACK CYLINDER TRKS CYLS VSAM' ,'200018 Brug af %-tegnet i TSO-kommandoer;;TSO REXX CLIST SYSEXEC SYSPROC LOAD' ,'200015 Udskriv indholdet af en ISPF-tabel;;REXX ISPF ISPEXEC TSO' ,'200014 Slå Abend-Aid fra i batch;;ABEND AID DUMP SYSUDUMP JCL' ,'200013 Optimering af kald til CSP fra COBOL-programmer;;CSP COBOL' ,'200012 Find rækker i DB2-tabel med samme nøgle;;SQL GROUP BY HAVING NESTED TABLE' ,'200011 Konkatenering på DD *;;JCL DD SYSIN SYSTSIN' ,'200010 Trace på DB2: DSN-kommandoen og CAF;;DB2 CAF TRACE DSN DSNTRACE TSO SQL' ,'200009 Asynkrone tasks i CICS: DELAY;;CICS START CANCEL DELAY REQID ICE' ,'200008 Asynkrone tasks i CICS: START og CANCEL;;CICS START CANCEL TRANSID REQID' ,'200007 ISPF EDIT labels .ZF og .ZL;;ISPF .ZF .ZFIRST .ZL .ZLAST .ZCSR FIND CHANGE EDIT' ,'200006 Display Active (DA) i SDSF af mange MVS'er.;;SDSF DA SYSNAME PREFIX CATALOG SYSPLEX' ,'200005 Kommuniker med en anden CICS fra din CICS.;;CICS CESF CRTE CONN' ,'200004 Snyd DB2-optimizeren med en IN-liste.;;SQL DB2 IN' ,'200003 Særlige valideringer i ISPF-paneler.;;ISPF TRUNC .TRAIL' ,'200002 DB2 CAF-interface.;;DB2 CAF' ,'200001 REXX variabelnavne.;;REXX' ,'199951 Hvad mon der venter i det nye årtusinde?;;2000 Y2K DB2 DATE' ,'199950 Fejlhåndtering i CICS.;;CICS HANDLE NOHANDLE EIBRESP' ,'199949 DB2 REORG UNLOAD EXTERNAL.;;DB2 REORG UNLOAD EXTERNAL JCL LOAD' ,'199948 Dynamisk allokering af REXX-biblioteker.;;REXX TSO ALTLIB EXECUTIL CLIST SYSEXEC SYSPROC' ,'199947 SYSIN-data genereret fra DB2 til direkte eksekvering.;;DB2 SQL DSNTIAUL UNLOAD JCL SUBSTR' ,'199946 Brug af ? i SQL EXPLAIN statement mod DB2.;;DB2 SQL EXPLAIN ?' ,'199945 ISPF Edit macro til gentagen kopiering af samme linie.;;REXX EDIT MACRO EDITMACRO FIND ISPF' ,'199944 ISPF log dataset.;;ISPF LOG LIST' ,'199943 Kig i storage med COBOL.;;COBOL ADDRESS SET POINTER STORAGE MVS CVT PSA' ,'199941 Restore af en HSM backup.;;TSO HSM BACKUP RESTORE HLIST RECOVER HRECOVER' ,'199940 En kvik DB2 reorganisering.;;DB2 ADRDSSU DFDSS REORG EXTENT EXTENTS' ,'199939 Status Req på CICS-program.;;CICS LINK LOAD XCTL CEMT PGMIDERR DFHRPL PPT NEWCOPY' ,'199938 "Døde breve" i MQS.;;MQS MQM MQ CSQUTIL DEADLETTER QUEUE' ,'199937 ISPF-kommandoen RETP.;;ISPF RETP RETRIEVE' ,'199936 GROUP BY på expressions i SQL.;;SQL GROUP BY EXPRESSION DB2 NESTED TABLE SUBSELECT' ,'199935 Returkode 0 fra TSO-batch.;;JCL TSO BATCH RC0 IEFBR14' ,'199934 Hvem bruger mit dataset.;;ENQ ENQUEUE GRS' ,'199933 CASE statement i SQL.;;DB2 SQL CASE' ,'199932 Hvor finder man oplysninger om COBOL abends.;;COBOL ABEND CICS CEBR SYSABOUT 1037 CEMT' ,'199931 Hvordan man giver andre adgang til sine egne datasets.;;RACF PE PERMIT ACCESS ALTER UPDATE LD' ,'199930 Browse og Edit af DB2-tabeller.;;DB2 FILEAID FILE-AID ACCESS CLIST REXX F2XNTRFC F2XNSAMP' ,'199929 Felterne PROJECT, GROUP og TYPE i ISPF.;;ISPF PROJECT GROUP TYPE TSO' ,'199928 Lav din egen bookshelf i BookManager.;;BOOKMANAGER BOOKMGR BOOKSHELF' ,'199927 Snyd med ISPF-kommandoer.;;ISPF REXX EDIT MACRO EDITMACRO' ,'199926 Den længe ventede tabel i DB2 version 5.;;SQL DB2 SYSDUMMY1 SPUFI CURRENT TIMESTAMP' ,'199925 Tabeller i REXX.;;REXX TABEL TABLE STEM' ,'199924 Interne procedurer i COBOL.;;COBOL NESTED INLINE' ,'199923 SQL-kald til konstatering af en rækkes eksistens.;;DB2 SQL EXISTS CURSOR UPDATE -811' ,'199922 Kolonnen MAX-RC i SDSF.;;SDSF MAX-RC RC CC CONDCODE STATUS ST' ,'199921 CUT-funktionen i 3270-emulatoren.;;3270 CUT ERASE' ,'199920 Lidt objekt-orienteret PL/1.;;PLI PL1 PL/1 OO OBJECT' ,'199919 DB2 og data sharing.;;DB2 LOG RBA LRSN STCK TOD SYSLGRNX DSN1COPY' ,'199918 Udskift et underprogram i et LOAD-modul.;;LOAD LINK LINKEDIT IEWL LINKAGE' ,'199917 Krydsreferencer mellem DB2-tabeller og programmer.;;DB2 SQL TABEL TABLE PROGRAM PACKAGE PLAN SYSPACKAGE SYSPLAN SYSTABAUTH' ,'199916 Synkronisering af jobs med DISP=OLD.;;JCL DISP DISP=OLD OLD DISP=MOD MOD' ,'199915 UNLOAD af DB2-data med DSNTIAUL.;;DB2 SQL JCL DSNTIAUL UNLOAD LOAD' ,'199914 Lidt om HSM recall og migrering.;;HSM TSO HRECALL HRECA HMIGRATE HMIG HQUERY HQ' ,'199913 Påske-tippet.' ,'199912 Datostempling i et LOAD-modul.;;LOAD DATO DATE AMBLIST JCL HEX LINKAGE' ,'199911 ISPF-værktøjet ISRDDN, herunder enqueues.;;ISPF ISRDDN ENQ ENQUEUE' ,'199910 Nem kopiering af datasets.;;ADRDSSU COPY KOPI DFDSS' ,'199909 SQL-kald til konstatering af data inkonsistens.;;DB2 SQL INKONSISTENS OUTER OUTTER JOIN INNER EXISTS' ,'199908 Diverse SDSF-kommandoer.;;SDSF XDC SJ //' ,'199907 Når et dataset er løbet fuldt.;;DATASET EXTENT EXTENTS ADRDSSU DFDSS' ,'199906 Diverse RACF-kommandoer.;;RACF TSO LU LG LD' ,'199905 TSO-kommandoen HQ.;;HSM HQ HQUERY' ,'199904 ISPF View kommandoen REPLACE.;;ISPF EDIT VIEW REPLACE' ,'199903 Konvertering af CHAR og VARCHAR til DECIMAL i DB2.;;DB2 SQL CHAR VARCHAR DECIMAL INTEGER NUMBER TAL' ,'199902 SPACE parameter på eksisterende dataset.;;JCL SPACE' ,'199901 DISP=MOD.;;JCL MOD NEW DISP' ,'199852 Liniekommandoen ? i CEMT.;;CICS CEMT ? TASK' ,'199851 ISPF Edit liniekommandoerne L og F.;;ISPF EDIT F FIRST L LAST' ,'199850 ISPF Edit macro ONLY.;;ISPF EDIT ONLY ISRONLY FIND EXCLUDE' ) function sst(findvalue) { document.cookie = 'find=' + findvalue if (document.cookie.indexOf('tiptype=e') < 0) document.location = 'tips.html' else document.location = 'tipse.html' } function ssi(findvalue) { document.cookie = 'find=' + findvalue if (document.cookie.indexOf('tiptype=e') < 0) document.location = 'tips.html' else document.location = 'tipse.html' } function searchvalue() { findfound = document.cookie.indexOf('find=') if (findfound < 0) return '' else { restcookie = document.cookie.substring(findfound + 5) semifound = restcookie.indexOf(';') if (semifound < 0) return restcookie else return restcookie.substring(0,semifound) } } function searchresult() { matchstart = 0 if (thisdate.getTime() > tipdate.getTime()) matchstart = 0 else if (thisdate.getMonth() < 1 && tipmmnew > 11) matchstart = 0 matchtext = searchvalue() matchtext = matchtext.toUpperCase() if (document.cookie.indexOf('tiptype=e') < 0) { matchlanguage = ' ' } else { matchlanguage = '*' } if (matchtext == '') { html = '' } else { if (matchlanguage == ' ') { html = '

  Der er følgende hits på ' + matchtext + ':' } else { html = '

  Tips found about ' + matchtext + ':' } } matchwords = matchtext.split(' ') for (i = matchstart; i < searchtexts.length; i++) { wordfound = -1 tiplanguage = searchtexts[i].substring(6,7) if (tiplanguage == matchlanguage || i == matchstart) wordfound = wordfound + 1 for (w = 0; w < matchwords.length; w++) { if (searchtexts[i].substring(7).toUpperCase().indexOf(matchwords[w]) >= 0) { wordfound = wordfound + 1 } } if (wordfound == matchwords.length) { href = '  ' if (tiplanguage == '*') { if (i == matchstart) { uge = 'Tip this week' uge = 'Last tip' } else { uge = 'Wk. ' + searchtexts[i].substring(4,6) + '/' + searchtexts[i].substring(0,4) } } else { if (i == matchstart) { if (document.URL.indexOf('tips.html') >= 0 || document.URL.indexOf('index.html') >= 0) { uge = 'Denne uges tip' uge = 'Sidste tip' } else { uge = 'Tip this week' uge = 'Last tip' } } else { uge = 'Uge ' + searchtexts[i].substring(4,6) + '/' + searchtexts[i].substring(0,4) } } tekst = searchtexts[i].substring(7) + ';;' html = html + '

' + href + uge + ':  ' + tekst.substring(0,tekst.indexOf(';;')) } } return html }