MIDRANGE-L Thread Index -- May 2024

Using SQL to replace characters less than Blank , Giovanni Arturi Re: Using SQL to replace characters less than Blank , Vern Hamberg R: Using SQL to replace characters less than Blank , Giovanni Arturi Re: Using SQL to replace characters less than Blank , Glenn Gundermann RE: Using SQL to replace characters less than Blank , Birgitta Hauser <Possible follow-ups> RE: Using SQL to replace characters less than Blank , VERNON HAMBERG Owner RE: Using SQL to replace characters less than Blank , Dan Bale RE: Using SQL to replace characters less than Blank , Birgitta Hauser RE: Using SQL to replace characters less than Blank , VERNON HAMBERG Owner RE: Using SQL to replace characters less than Blank , Dan Bale RE: Using SQL to replace characters less than Blank , VERNON HAMBERG Owner Re: R: Using SQL to replace characters less than Blank , VERNON HAMBERG Owner Has anyone ever created an Index Table that included a JOIN table? , Timothy Feldmeier RE: Has anyone ever created an Index Table that included a JOIN table? , Birgitta Hauser Re: Has anyone ever created an Index Table that included a JOIN table? , Patrik Schindler <Possible follow-ups> Re: Has anyone ever created an Index Table that included a JOIN table? , VERNON HAMBERG Owner RE: Has anyone ever created an Index Table that included a JOIN table? , Therrien, Paul Re: Has anyone ever created an Index Table that included a JOIN table? , Mark Waterbury Re: Has anyone ever created an Index Table that included a JOIN table? , Vern Hamberg Re: Has anyone ever created an Index Table that included a JOIN table? , Alan (cfuture) Cassidy Re: Has anyone ever created an Index Table that included a JOIN table? , Alan (cfuture) Cassidy Re: Has anyone ever created an Index Table that included a JOIN table? , Vern Hamberg Re: Has anyone ever created an Index Table that included a JOIN table? , Alan (cfuture) Cassidy Re: Has anyone ever created an Index Table that included a JOIN table? , Vern Hamberg . Re: Has anyone ever created an Index Table that included a Join , Timothy Feldmeier Re: . Re: Has anyone ever created an Index Table that included a Join , Charles Wilt RE: . Re: Has anyone ever created an Index Table that included a Join , Darren Strong <Possible follow-ups> Re: . Re: Has anyone ever created an Index Table that included a Join , VERNON HAMBERG Owner Idea: Add license expiration to system dashboard view in Navigator , Rob Berendt Re: Idea: Add license expiration to system dashboard view in Navigator , Gavin Inman Re: Idea: Add license expiration to system dashboard view in Navigator , Jim Oberholtzer Re: Idea: Add license expiration to system dashboard view in Navigator , Larry "DrFranken" Bolhuis Idea: Add OS license expiration as an optional column on list of partitions in HMC , Rob Berendt Re: Idea: Add OS license expiration as an optional column on list of partitions in HMC , Gavin Inman Re: Idea: Add OS license expiration as an optional column on list of partitions in HMC , Rob Berendt Re: Idea: Add OS license expiration as an optional column on list of partitions in HMC , Jim Oberholtzer Re: Has anyone ever created an Index Table that included a JOIN table , Timothy Feldmeier RE: Has anyone ever created an Index Table that included a JOIN table , Birgitta Hauser Re: Has anyone ever created an Index Table that included a JOIN table , Vern Hamberg AFPDS Color printing , konsult RE: AFPDS Color printing , Sean Courtney <Possible follow-ups> RE: AFPDS Color printing , konsult Latest Technology Refresh news on IBM i , Rob Berendt re: is it possible to start multiple JVMs in different activation groups in the same job? , Ali Ekinci Re: is it possible to start multiple JVMs in different activation groups in the same job? , Jon Paris UPS JSON API Response , Michael Fulmer RE: [EXTERNAL] UPS JSON API Response , Greg Wilburn Re: RE: [EXTERNAL] UPS JSON API Response , Michael Fulmer RE: RE: [EXTERNAL] UPS JSON API Response , Greg Wilburn Re: RE: [EXTERNAL] UPS JSON API Response , Brad Stone RE: RE: [EXTERNAL] UPS JSON API Response , (WalzCraft) Jerry Forss Re: RE: RE: [EXTERNAL] UPS JSON API Response , Michael Fulmer Re: RE: [EXTERNAL] UPS JSON API Response , Brad Stone RE: UPS JSON API Response , Greg Wilburn Re: UPS JSON API Response , Jon Paris RE: UPS JSON API Response , Greg Wilburn Re: UPS JSON API Response , Jon Paris SQL: Return one row with multiple columns generated from a single column from multiple rows , Dan Bale Re: SQL: Return one row with multiple columns generated from a single column from multiple rows , Buck Calabro RE: SQL: Return one row with multiple columns generated from a single column from multiple rows , Dan Bale Re: SQL: Return one row with multiple columns generated from a single column from multiple rows , Buck Calabro Re: SQL: Return one row with multiple columns generated from a single column from multiple rows , Charles Wilt SQL procedure that will have server name passed to it to run query on 3-part name , Dan Bale Re: SQL procedure that will have server name passed to it to run query on 3-part name , Charles Wilt IBM Power S1012 server provides cost-optimized performance and scale for businesses in pursuit of IT excellence , Rob Berendt Re: IBM Power S1012 server provides cost-optimized performance and scale for businesses in pursuit of IT excellence , Rob Berendt IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Jack Woehr RE: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , stefan RE: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Dan Sundt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Patrik Schindler Re[2]: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Holger Scherer Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Patrik Schindler Re: IBM adds new capabilities and enhancements with IBM i 7.5 Technology Refresh 4 , Rob Berendt IBM adds new capabilities and enhancements with IBM i 7.4 Technology Refresh 10 , Rob Berendt Lotta IBM i stuff going on .... , Michael Mayer RE: IBM adds new capabilities and enhancements with IBM i 7.5 , Michael Mayer iACS Font Sizing , Sam_L How to find user profile who *created* an IFS object? , Dan Bale Re: How to find user profile who *created* an IFS object? , Patrik Schindler Re: How to find user profile who *created* an IFS object? , Bryan Dietz Re: How to find user profile who *created* an IFS object? , Vern Hamberg IFS allow save object attribute? , James Ash Re: IFS allow save object attribute? , Jim Oberholtzer Re: IFS allow save object attribute? , Evan Harris Re: IFS allow save object attribute? , Rob Berendt RE: [ EXTERNAL ]Re: IFS allow save object attribute? , James Ash Re: [ EXTERNAL ]Re: IFS allow save object attribute? , Rob Berendt Using SQL to view a spoolfile , smith5646midrange Re: Using SQL to view a spoolfile , Rob Berendt RE: Using SQL to view a spoolfile , smith5646midrange Re: Using SQL to view a spoolfile , Rob Berendt <Possible follow-ups> RE: Using SQL to view a spoolfile , Glenn Gundermann Re: Using SQL to view a spoolfile , Peter Dow Learn Python From Scratch , (WalzCraft) Jerry Forss Re: Learn Python From Scratch , Jack Woehr Re: Learn Python From Scratch , Jack Woehr RE: External Re: Learn Python From Scratch , (WalzCraft) Jerry Forss Re: External Re: Learn Python From Scratch , Jack Woehr RE: Learn Python From Scratch , smith5646midrange Re: Learn Python From Scratch , Sam_L Re: Learn Python From Scratch , Jack Woehr Re: Learn Python From Scratch , Sam_L Re: Learn Python From Scratch , Jim Oberholtzer Re: Learn Python From Scratch , John Yeung Re: Learn Python From Scratch , Niels Liisberg Re: Learn Python From Scratch , Jack Woehr Re: Learn Python From Scratch , Jim Oberholtzer Re: Learn Python From Scratch , Javier Sanchez Re: Learn Python From Scratch , Scott Klement Re: Learn Python From Scratch , John Yeung Re: Learn Python From Scratch , Pete Helgren <Possible follow-ups> Re: Learn Python From Scratch , VERNON HAMBERG Owner Re: Learn Python From Scratch , Scott Klement Re: Learn Python From Scratch , Vern Hamberg RE: External Re: Learn Python From Scratch , (WalzCraft) Jerry Forss Power UP , Thomas Burrows Re: Power UP , Javier Sanchez Re: Power UP , Thomas Burrows ACS Run SQL Scripts Open dialog box , Greg Wilburn Re: ACS Run SQL Scripts Open dialog box , Jon Paris RE: ACS Run SQL Scripts Open dialog box , Greg Wilburn DCM V5R4 , Ed Guevara Re: DCM V5R4 , Brad Stone Re: DCM V5R4 , Ed Guevara Re: DCM V5R4 , Brad Stone Re: DCM V5R4 , Ed Guevara Re: DCM V5R4 , Ed Guevara Re: DCM V5R4 , Brad Stone Re: DCM V5R4 , Rob Berendt Re: DCM V5R4 , Ed Guevara 5250 Sessions in a browser , Bob Schwartz RE: [EXTERNAL] 5250 Sessions in a browser , Greg Wilburn RE: 5250 Sessions in a browser , Brian May Re: 5250 Sessions in a browser , John Yeung Re: 5250 Sessions in a browser , Jon Paris Re: [External Sender - Caution!] Re: 5250 Sessions in a browser , Bob Schwartz Re: 5250 Sessions in a browser , Justin Taylor Re: 5250 Sessions in a browser , Niels Liisberg Re: 5250 Sessions in a browser , Diego E. KESSELMAN <Possible follow-ups> Re: 5250 Sessions in a browser , Andrew Lopez (SXS US) SQL0802 Type 12 using LISTAGG , Greg Wilburn RE: SQL0802 Type 12 using LISTAGG , Birgitta Hauser RE: SQL0802 Type 12 using LISTAGG , Greg Wilburn Software support costs , Michael Quigley Re: Software support costs , Jim Oberholtzer About question : HMC and Operations Console. , aa aa Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx Re: Users with *ALLOBJ , Jim Oberholtzer Re: Users with *ALLOBJ , Justin Taylor Re: Users with *ALLOBJ , Jim Oberholtzer Re: Users with *ALLOBJ , Chris Pando RE: Users with *ALLOBJ , Roger Harman Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx RE: Users with *ALLOBJ , Stephen Landess Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx Re: Users with *ALLOBJ , Gavin Inman Re: Users with *ALLOBJ , Mark Waterbury Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx <Possible follow-ups> Re: Users with *ALLOBJ , Tim Rowe Re: Users with *ALLOBJ , ubelhor@xxxxxxxxxxxxx SQL0206: Column or global variable V_LPSERVER not found , Dan Bale Re: SQL0206: Column or global variable V_LPSERVER not found , Charles Wilt RE: SQL0206: Column or global variable V_LPSERVER not found , Dan Bale RE: SQL0206: Column or global variable V_LPSERVER not found , Birgitta Hauser Re: SQL0206: Column or global variable V_LPSERVER not found , Niels Liisberg RE: SQL0206: Column or global variable V_LPSERVER not found , Dan Bale RE: SQL0206: Column or global variable V_LPSERVER not found , Dan Bale CPF3501 "Job is already being serviced, traced, or debugged." using ACS SQL system debugger , Dan Bale RE: CPF3501 "Job is already being serviced, traced, or debugged." using ACS SQL system debugger , Birgitta Hauser Cognos , Greg Wilburn RE: Cognos , Darren Strong <Possible follow-ups> RE: Cognos , Richard Schoen RE: Cognos , Neifert, Brian RE: Cognos , Greg Wilburn CL command to check whether an active job of a given name exists? , James H. H. Lampert Re: CL command to check whether an active job of a given name exists? , Chris Pando Re: CL command to check whether an active job of a given name exists? , Bdietz400 <Possible follow-ups> Re: CL command to check whether an active job of a given name exists? , VERNON HAMBERG Owner Re: CL command to check whether an active job of a given name exists? , Javier Sanchez Re: CL command to check whether an active job of a given name exists? , VERNON HAMBERG Owner Re: CL command to check whether an active job of a given name exists? , Javier Sanchez Re: CL command to check whether an active job of a given name exists? , James H. H. Lampert Re: CL command to check whether an active job of a given name exists? , Javier Sanchez Re: CL command to check whether an active job of a given name exists? , James H. H. Lampert Re: CL command to check whether an active job of a given name exists? , Rich Loeber RE: CL command to check whether an active job of a given name exists? , Roger Harman Re: CL command to check whether an active job of a given name exists? , Patrik Schindler AW: CL command to check whether an active job of a given name exists? , Sean Courtney RE: CL command to check whether an active job of a given name exists? , Dan Bale AW: CL command to check whether an active job of a given name exists? , Sean Courtney Re: CL command to check whether an active job of a given name exists? , Jim Oberholtzer RE: CL command to check whether an active job of a given name exists? , Birgitta Hauser Re: CL command to check whether an active job of a given name exists? , Buck Calabro Re: CL command to check whether an active job of a given name exists? , James H. H. Lampert Re: CL command to check whether an active job of a given name exists? , Jim Oberholtzer Re: CL command to check whether an active job of a given name exists? , Charles Wilt Re: CL command to check whether an active job of a given name exists? , VERNON HAMBERG Owner Re: CL command to check whether an active job of a given name exists? , Jim Oberholtzer RE: CL command to check whether an active job of a given name exists? , Roger Harman RE: CL command to check whether an active job of a given name exists? , VERNON HAMBERG Owner RE: CL command to check whether an active job of a given name exists? , Roger Harman Re: CL command to check whether an active job of a given name exists? , Vern Hamberg Re: CL command to check whether an active job of a given name exists? , Scott Klement Re: CL command to check whether an active job of a given name exists? , Gad Miron Excessive RSTOBJ job run time , Buzz Fenner Re: Excessive RSTOBJ job run time , Jim Oberholtzer Re: Excessive RSTOBJ job run time , Bdietz400 <Possible follow-ups> Re: Excessive RSTOBJ job run time , Buzz Fenner RE: CL command to check whether an active job of a given name , konsult How to insert a "special" row when SQLEXCEPTION happens? , Dan Bale RE: How to insert a "special" row when SQLEXCEPTION happens? , Birgitta Hauser Weird model numbers: reality check , James H. H. Lampert Re: Weird model numbers: reality check , Brad Stone Re: Weird model numbers: reality check , James H. H. Lampert Re: Weird model numbers: reality check , Javier Sanchez Flashing power Light on P8 System Turned Off , Brad Stone Re: Flashing power Light on P8 System Turned Off , Don Brown Re: Flashing power Light on P8 System Turned Off , Brad Stone Re command to check if job is active , konsult DDS PF-TIMESTAMP 32 12 , Justin Taylor RE: DDS PF-TIMESTAMP 32 12 , Birgitta Hauser Re: DDS PF-TIMESTAMP 32 12 , Justin Taylor Re: DDS PF-TIMESTAMP 32 12 , Charles Wilt AFP , ubelhor@xxxxxxxxxxxxx RE: AFP , Roger Harman Re: AFP , ubelhor@xxxxxxxxxxxxx Re: AFP , Brad Stone