midrange.com -- MIDRANGE-L Thread Index -- July 2013

A SQL UDF GENSYSUUID in DB2 SQL , Vengoal Chang
- AW: A SQL UDF GENSYSUUID in DB2 SQL , Birgitta Hauser
RE: The Future of IBM .. , Gerald Kern
- RE: The Future of IBM .. , Paul Nelson
- <Possible follow-ups>
- RE: The Future of IBM .. , Dan Kimmel
- Re: The Future of IBM .. , David Gibbs
*** ADMIN: Contact information for domain registrations , David Gibbs
*** ADMIN: Network reconfiguration , David Gibbs
how to use sql distinct in CL? , Hoteltravelfundotcom
- Re: how to use sql distinct in CL? , Jim Oberholtzer
- Re: how to use sql distinct in CL? , Vernon Hamberg
- Re: how to use sql distinct in CL? , rob
- <Possible follow-ups>
- Re: how to use sql distinct in CL? , CRPence
- Re: AW: how to use sql distinct in CL? , Voris, John
0KB files in IFS , Gary Thompson
- Re: 0KB files in IFS , rob
- Re: 0KB files in IFS , Nathan Andelin
- Re: 0KB files in IFS , rob
- Re: 0KB files in IFS , Vern Hamberg
How do you determine what cpw your system is rated at? , rob
- Re: How do you determine what cpw your system is rated at? , rob
- Re: How do you determine what cpw your system is rated at? , DrFranken
Command MOVOUTQ with List Spooled Files (QUSLSPL) API , Vengoal Chang
Impact of deleting QCPFRMIMPF and QCPTOIMPF dtaaras - CPYTOIMPF and CPYFRMIMP functionality changes , Steinmetz, Paul
- Re: Impact of deleting QCPFRMIMPF and QCPTOIMPF dtaaras - CPYTOIMPF and CPYFRMIMP functionality changes , rob
- Re: Impact of deleting QCPFRMIMPF and QCPTOIMPF dtaaras - CPYTOIMPF and CPYFRMIMP functionality changes , Michael Ryan
SF99582 and SF99368 ordered on physical media , Gerald Kern
- Re: SF99582 and SF99368 ordered on physical media , DrFranken
Interesting comment on CQE in product documentation , Vernon Hamberg
- <Possible follow-ups>
- Re: Interesting comment on CQE in product documentation , CRPence
Question: Operations Console via TCPIP? , Rene K.
- Re: Question: Operations Console via TCPIP? , DrFranken
Device setting to save all splf? , Justin Taylor
- RE: Device setting to save all splf? , Steinmetz, Paul
- Re: Device setting to save all splf? , rob
How to identify a runaway job , Denis Robitaille
- Re: How to identify a runaway job , Clay B Carley
- Re: How to identify a runaway job , lketzes
- Re: How to identify a runaway job , Luis Rodriguez
- Re: How to identify a runaway job , Vernon Hamberg
- Re: How to identify a runaway job , Martin Rowe
BRMS tape drive on LPAR , Vincent Forbes
- Re: BRMS tape drive on LPAR , DrFranken
- Re: BRMS tape drive on LPAR , rob
SSL cert out of sync , Jerry Draper
- Re: SSL cert out of sync , Nathan Andelin
OpenSSH + GCC on PASE , Yvan Janssens
- Re: OpenSSH + GCC on PASE , Mark S Waterbury
- Re: OpenSSH + GCC on PASE , Scott Klement
SQL with concantenate: , Jim Oberholtzer
- Re: SQL with concantenate: , rob
- Re: SQL with concantenate: , Charles Wilt
- AW: SQL with concantenate: , Birgitta Hauser
Re: SQL with concatenate , CRPence
- Re: SQL with concatenate , Jim Oberholtzer
SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT , Needles,Stephen J
- Re: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT , rob
- <Possible follow-ups>
- Re: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT , Ken Sims
RESOLVED: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT , Needles,Stephen J
- Re: RESOLVED: SQL-inconsistent results using XMLELEMENT, XMLSERIALIZE, XMLCONCAT , rob
Database design: Sales "position" uniquely defined and permanent; people are impermanent, changeble , Eric Lehti
- Re: Database design: Sales "position" uniquely defined and permanent; people are impermanent, changeble , Nathan Andelin
- Re: Database design: Sales "position" uniquely defined and permanent; people are impermanent, changeble , rob
Re: SF99582 and SF99368 ordered on physical media (DrFranken) , Gerald Kern
Profile Clone API , Jack Kingsley
- Re: Profile Clone API , John McKee
Re: Database design: Sales "position" uniquely defined and permanent; people are impermanent, changeble , TheBorg
SFTP Arcana..... , ALopez
- Re: SFTP Arcana..... , rob
- RE: SFTP Arcana..... , brad.lovelady
- <Possible follow-ups>
- Re: SFTP Arcana..... , ALopez
Upgrading Load Source Disk , Rick Hill
- Re: Upgrading Load Source Disk , Jim Oberholtzer
QDSPSIGNINF troubles , Roberto José Etcheverry Romero
Parse Spooled Files , Dan Kimmel
- Re: Parse Spooled Files , Vern Hamberg
- Re: Parse Spooled Files , Scott Klement
- Re: Parse Spooled Files , Nick_Radich
- <Possible follow-ups>
- RE: Parse Spooled Files , Richard Schoen
- Re: Parse Spooled Files , CRPence
- Re: Parse Spooled Files , CRPence
Re: QDSPSGNINF troubles , CRPence
- Re: QDSPSGNINF troubles , Roberto José Etcheverry Romero
Old Alerts ? , Jack Kingsley
- Re: Old Alerts ? , Vernon Hamberg
Hop in your way back machines , Paul Nelson
- RE: Hop in your way back machines , DeLong, Eric
How to track failed jobs , Steve McKay
- RE: How to track failed jobs , Lindstrom, Scott R.
- RE: How to track failed jobs , Dan Kimmel
- RE: How to track failed jobs , Eric Lehti
- <Possible follow-ups>
- Re: How to track failed jobs , Buck Calabro
- Re: How to track failed jobs , CRPence
Tape drive question , Midrange Information
- Re: Tape drive question , Jim Oberholtzer
- RE: Tape drive question , Steinmetz, Paul
Secure FTP. , Ray_Sprinkle
- Re: Secure FTP. , Tim Bronski
Display screen widths , Cyndi Bradberry
- Re: Display screen widths , James H. H. Lampert
- Re: Display screen widths , franz400
- Display screen widths - Answer Found ! , Cyndi Bradberry
- Re: Display screen widths , Charles Wilt
SQL SP - Using Decimal (8,6) for Parameters , Michael Ryan
- Re: SQL SP - Using Decimal (8,6) for Parameters , Jon Paris
- AW: SQL SP - Using Decimal (8,6) for Parameters , Birgitta Hauser
- <Possible follow-ups>
- Re: SQL SP - Using Decimal (8,6) for Parameters , Hiebert, Chris
DMPSYSOBJ to print contents of concealed system objects , Eric Lehti
- <Possible follow-ups>
- Re: DMPSYSOBJ to print contents of concealed system objects , CRPence
Re: Old Alerts , Gad Miron
- Re: Old Alerts , Vernon Hamberg
Aldon Lifecycle Manager for System i: is it possible to add OBJECTS to a REQUEST programmatically? Rel 07.5G , Stone, Joel
- RE: Aldon Lifecycle Manager for System i: is it possible to add OBJECTSto a REQUEST programmatically? Rel 07.5G , Paul Nelson
job queues , Hoteltravelfundotcom
- Re: job queues , Jerry Draper
- Re: job queues , DrFranken
- Re: job queues , Jim Oberholtzer
- Re: job queues , Scott Klement
- RE: job queues , Eric Lehti
- <Possible follow-ups>
- Re: job queues , Buck Calabro
TimeZoNe/400 , Kellems, Cary (EXTERNAL)
Scan Source, PDM option 25, find string, dump to outfile , Steinmetz, Paul
- Re: Scan Source, PDM option 25, find string, dump to outfile , Mark S Waterbury
- Re: Scan Source, PDM option 25, find string, dump to outfile , Pat Barber
- <Possible follow-ups>
- Re: Scan Source, PDM option 25, find string, dump to outfile , CRPence
- Re: Scan Source, PDM option 25, find string, dump to outfile , Buck Calabro
Adapting certificates so that Tomcat can use them? , James H. H. Lampert
- Re: Adapting certificates so that Tomcat can use them? , Jack Kingsley
- Re: Adapting certificates so that Tomcat can use them? , Mark Murphy/STAR BASE Consulting Inc.
Lost page up/page down functions in emulation , Boling, David E.
- Re: Lost page up/page down functions in emulation , Alexei Baranov
- Re: Lost page up/page down functions in emulation , Mark Murphy/STAR BASE Consulting Inc.
- RE: Lost page up/page down functions in emulation , paultherrien
- RE: Lost page up/page down functions in emulation , Boling, David E.
SQL Server Jobs , Graves, Chuck
- RE: SQL Server Jobs , Monnier, Gary
- <Possible follow-ups>
- Re: SQL Server Jobs , TheBorg
- Re: SQL Server Jobs , TheBorg
Operations Console Connection Problem , Jeff Glenn
- Re: Operations Console Connection Problem , Roberto José Etcheverry Romero
- Re: Operations Console Connection Problem , Kirk Goins
Sharp MFP and Printer Overlays is DOG SLOW , Kirk Goins
- Re: Sharp MFP and Printer Overlays is DOG SLOW , franz400
- <Possible follow-ups>
- Re: Sharp MFP and Printer Overlays is DOG SLOW , TheBorg
Re: WHO is connecting via QRWTSRVR jobs and editing data? , fbocch2595
CRTDUPOBJ: how to retain the create date and usage info , Stone, Joel
- RE: CRTDUPOBJ: how to retain the create date and usage info , Monnier, Gary
- Re: CRTDUPOBJ: how to retain the create date and usage info , Rich Loeber
- Re: CRTDUPOBJ: how to retain the create date and usage info , Mark S Waterbury
HMC (hardware management console) web security certificate not trusted , Eric Lehti
- RE: HMC (hardware management console) web security certificate not trusted , Bakutis, Becky
- Re: HMC (hardware management console) web security certificate not trusted , Yvan Janssens
- Re: HMC (hardware management console) web security certificate not trusted , Nathan Andelin
Who is our account administrator, and how do we get customer numbers added to it? , rob
SQL0444 work around? , fbocch2595
- Re: SQL0444 work around? , rob
- AW: SQL0444 work around? , Birgitta Hauser
- Re: SQL0444 work around? , Mike Bardin
- <Possible follow-ups>
- Re: SQL0444 work around? , CRPence
- AW: SQL0444 work around? , Birgitta Hauser
Getting started with an AS/400 (9406 model 720) , Camiel Vanderhoeven
- RE: Getting started with an AS/400 (9406 model 720) , Paul Fenstermacher
- RE: Getting started with an AS/400 (9406 model 720) , Mark Murphy/STAR BASE Consulting Inc.
- Re: Getting started with an AS/400 (9406 model 720) , Mark Murphy/STAR BASE Consulting Inc.
external drive as/400 , Hoteltravelfundotcom
- <Possible follow-ups>
- Re: external drive as/400 , CRPence
Re: Who is our account administrator, and how do we get customer numbers added to it? , Sam_L
- Re: Who is our account administrator, and how do we get customer numbers added to it? , Jack Kingsley
- Re: Who is our account administrator, and how do we get customer numbers added to it? , rob
Slip install of 7.1 LIC and OS - Any gotcha's? , Charles Wilt
- RE: Slip install of 7.1 LIC and OS - Any gotcha's? , Bakutis, Becky
Resolved: Automated receipt of email attachemnets , Peter Connell
RPG and Binary , Mike Cunningham
- Re: RPG and Binary , Charles Wilt
SFTP connects then hangs , Keith McCully
- SFTP connects then hangs , Keith McCully
got bitten by RTVJOBA date , dale janus
- Re: got bitten by RTVJOBA date , Scott Klement
- <Possible follow-ups>
- Re: got bitten by RTVJOBA date , CRPence
RE: Flat file comparison , Alan Shore
LAN Console - Remote Control Panel - N/A when system powered off? , Charles Wilt
- Re: LAN Console - Remote Control Panel - N/A when system powered off? , Roberto José Etcheverry Romero
- Re: LAN Console - Remote Control Panel - N/A when system powered off? , DrFranken
IBM's version of bind is obsolete. , rob
- Re: IBM's version of bind is obsolete. , Yvan Janssens
RE: Flat file comparision , george_kinney
Submitting a batch job from a CL program, and then waiting for it to end? , James H. H. Lampert
- Re: Submitting a batch job from a CL program, and then waiting for it to end? , Charles Wilt
- Re: Submitting a batch job from a CL program, and then waiting for it to end? , Mark S Waterbury
- RE: Submitting a batch job from a CL program, and then waiting for it to end? , Monnier, Gary
query break is? , Hoteltravelfundotcom
- RE: query break is? , Tom E Stieger
- Re: query break is? , Vern Hamberg
- <Possible follow-ups>
- Re: query break is? , CRPence
- Re: query break is? , Sam_L
Best Practices - PHP, Stored Procedures, SQL, Library List , Michael Ryan
- Re: Best Practices - PHP, Stored Procedures, SQL, Library List , Glenn Hopwood
Re: Submitting a batch job from a CL program, and then waiting for it to end? , CRPence
- <Possible follow-ups>
- Re: Submitting a batch job from a CL program, and then waiting for it to end? , Buck Calabro
HMC question , optional info0rmation
- Re: HMC question , rob
- Re: HMC question , DrFranken
Single user input inhibitted on all seesions to same LPAR for 5 to 10 minutes , Steinmetz, Paul
- Re: Single user input inhibitted on all seesions to same LPAR for 5 to 10 minutes , Bryan Dietz
- Re: Single user input inhibitted on all seesions to same LPAR for 5 to 10 minutes , rob
non database license of IBM i or "application server license" , rob
- Re: non database license of IBM i or "application server license" , Jim Oberholtzer
SQL select seems to be creating a lock on a file , Alan Shore
- Re: SQL select seems to be creating a lock on a file , rob
- <Possible follow-ups>
- Re: SQL select seems to be creating a lock on a file , CRPence
LTO5 dynamic speed matching, Saves and DUPS , Steinmetz, Paul
- Re: LTO5 dynamic speed matching, Saves and DUPS , rob
- Re: LTO5 dynamic speed matching, Saves and DUPS , Evan Harris
V3700 fibre attach "native" DASD , Jerry Draper
- Re: V3700 fibre attach "native" DASD , DrFranken
Leave outside of DO group??? , DrFranken
- RE: Leave outside of DO group??? , Paul Nelson
- Re: Leave outside of DO group??? , James H. H. Lampert
- RE: Leave outside of DO group??? , Gary Thompson
- RE: Leave outside of DO group??? , Terry Nonamaker
- Re: Leave outside of DO group??? , Mark S Waterbury
- Re: Leave outside of DO group??? , rob
- RE: Leave outside of DO group??? , Dan Kimmel
- <Possible follow-ups>
- Re: Leave outside of DO group??? , CRPence
- Re: Leave outside of DO group??? , Horn, Jim
Printing to PDF with logo , Chris Chambers
- Re: Printing to PDF with logo , Jeff Young
- Re: Printing to PDF with logo , Vernon Hamberg
- Re: Printing to PDF with logo , rob
- RE: Printing to PDF with logo , Dan Kimmel
- Re: Printing to PDF with logo , Luis Rodriguez
New command SNDSMTPEMM , rob
- Re: New command SNDSMTPEMM , Bryan Dietz
- RE: New command SNDSMTPEMM , Anderson, Kurt
- <Possible follow-ups>
- Re: New command SNDSMTPEMM , Richard Schoen
- Re: New command SNDSMTPEMM , Richard Schoen
Library List - Stored Procedure , Michael Ryan
- Re: Library List - Stored Procedure , rob
- <Possible follow-ups>
- Re: Library List - Stored Procedure , CRPence
arp statics? , Miguel Peralta
Activation group quandaries , David Gibbs
- Re: Activation group quandaries , Jon Paris
- RE: Activation group quandaries , Dan Kimmel
- <Possible follow-ups>
- Re: Activation group quandaries , CRPence
Maximum size of guest partition , Evan Harris
- Re: Maximum size of guest partition , DrFranken
iasp cheat sheet , Jack Kingsley
locking an ifs directory , Alan Shore
- RE: locking an ifs directory , Steinmetz, Paul
- Re: locking an ifs directory , Jim Oberholtzer
cloud backup services , Mike Cunningham
- Re: cloud backup services , Nathan Andelin
- Re: cloud backup services , DrFranken
- <Possible follow-ups>
- Re: cloud backup services , Richard Schoen
- Re: cloud backup services , Jim Bostwick
RE: cloud backup services - Dropbox , Richard Schoen
- RE: cloud backup services - Dropbox , Paul Nelson
- <Possible follow-ups>
- RE: cloud backup services - Dropbox , John Allen
Looking for someone who does Linux development on Power , Jon Paris
% Temp Addresses , Bakutis, Becky
- Re: % Temp Addresses , DrFranken
latest packaging of IBM Rational Developer for i , J Franz
- Re: latest packaging of IBM Rational Developer for i , broehmer
- <Possible follow-ups>
- Re: latest packaging of IBM Rational Developer for i , CRPence
- Re: latest packaging of IBM Rational Developer for i , CRPence
SAVSYS to IMGCLG then to DVD on PC , fbocch2595
- Re: SAVSYS to IMGCLG then to DVD on PC , DrFranken
- Re: SAVSYS to IMGCLG then to DVD on PC , rob
- <Possible follow-ups>
- SAVSYS to IMGCLG then to DVD on PC , Monty G. James
moving DB2 data to a SQL Server , Hoteltravelfundotcom
- Re: moving DB2 data to a SQL Server , Alan Campin
- <Possible follow-ups>
- Re: moving DB2 data to a SQL Server , D*B
DCM verisign ? , Jack Kingsley
- Re: DCM verisign ? , Bradley Stone
RE: cloud services with new development on IBM i on Power , Holger Scherer
QILE activation group? , James H. H. Lampert
- Re: QILE activation group? , Scott Klement
- RE: QILE activation group? , Dan Kimmel
File Size not as expected , Anderson, Kurt
- <Possible follow-ups>
- Re: File Size not as expected , CRPence
ssts0200 format, system date and time , rob
- Re: ssts0200 format, system date and time , Tim Bronski
- Re: ssts0200 format, system date and time , Alan Campin
- RE: ssts0200 format, system date and time , Dan Kimmel
- Re: ssts0200 format, system date and time , Bryan Dietz
- <Possible follow-ups>
- Re: ssts0200 format, system date and time , CRPence
RUNSQLSTM with commit(*ALL) , Marasco, Jon
- <Possible follow-ups>
- Re: RUNSQLSTM with commit(*ALL) , CRPence
What is the suse linux equivalent of QUPSDLYTIM? , rob
- Re: What is the suse linux equivalent of QUPSDLYTIM? , David Gibbs
*** ADMIN: Banner ad program , David Gibbs
iSeries Navigator woes , Matt Olson
- RE: iSeries Navigator woes , Gary Thompson
- Re: iSeries Navigator woes , rob
Moving to V5R4 , Dave Boettcher
- Re: Moving to V5R4 , Jim Oberholtzer
- Re: Moving to V5R4 , rob
Auto restarting iNav monitors , Jim Essinger
- Re: Auto restarting iNav monitors , Jim Oberholtzer
- Re: Auto restarting iNav monitors , Bryan Dietz
CCSID on V5R4 to be set when connecting to an external db2 luw , carlo Lunghi
- RE: CCSID on V5R4 to be set when connecting to an external db2 luw , Dan Kimmel
- <Possible follow-ups>
- Re: CCSID on V5R4 to be set when connecting to an external db2 luw , CRPence
TLS 1.1 and 1.2 , Mike Cunningham
- Re: TLS 1.1 and 1.2 , Bradley Stone
- Re: TLS 1.1 and 1.2 , Dawn May
TechExcel - Help desk , Hoteltravelfundotcom
Sql statement vs Sql View performance , Gary Thompson
- RE: Sql statement vs Sql View performance , Needles,Stephen J
- Re: Sql statement vs Sql View performance , Nathan Andelin
- <Possible follow-ups>
- Re: Sql statement vs Sql View performance , CRPence
Multiple Guested LPARS Backup Approach , Evan Harris
- Re: Multiple Guested LPARS Backup Approach , Carl J Novit
- Re: Multiple Guested LPARS Backup Approach , rob