When using IfNull in my SQL, records are ignored
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]
Answer Question
| December 24, 2010 12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL
I know my data table has nulls in it. If my select statement doesn’t include those fields, I get hundreds of records. If I include those fields with an IfNull, it skips all but 4 records. Here’s my testing snippet: C/Exec sql C+ DECLARE C1 CURSOR FOR C+ SELECT C+ accountID, C+ ifNull(address,’ ‘) C+ [...]
Answer Question
| December 24, 2010 12:10 AM
AS/400, AS/400 Records, Data Tables, RPG, SQL
Report / File repository for AS/400 V5R4
Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition [...]
Answer Question
| December 20, 2010 9:33 PM
AS/400, CSV, CSV file format, Repository, V5R4
Currently we have a home grown web application where we send our reports from the AS400 so our clients can view them. They are converted into a Monarch format. We would like to replace this with something else. We need to be able to put out .csv files, .pbf files and other types in addition [...]
Answer Question
| December 20, 2010 9:33 PM
AS/400, CSV, CSV file format, Repository, V5R4
Upgrading iSeries HMC 3550
Can anyone point me to some good information about upgrading an HMC? I am getting ready to perform my first of many HMC upgrades and would like to be able to review the documewntation and get some pointers concerning upgrading from a release below V6.1.3 to V7.3.4.
Answer Question
| December 31, 2010 9:24 PM
HMC, HMC updates, HMC V7.3.4, iSeries
Can anyone point me to some good information about upgrading an HMC? I am getting ready to perform my first of many HMC upgrades and would like to be able to review the documewntation and get some pointers concerning upgrading from a release below V6.1.3 to V7.3.4.
Answer Question
| December 31, 2010 9:24 PM
HMC, HMC updates, HMC V7.3.4, iSeries
AS/400 display format
is there any possibility to define more than 9999 display formats?
Answer Question
| December 21, 2010 6:05 PM
AS/400 Display File, AS400 printing issue, Display File
is there any possibility to define more than 9999 display formats?
Answer Question
| December 21, 2010 6:05 PM
AS/400 Display File, AS400 printing issue, Display File
FTP from QTXTSRC
I previously sent this question around 2 A.M. est. This revised version should be more coherent. How do you send data in a QTXTSRC member via the IFS in order to FTP it from a dos prompt or in a CLP? I created a stream file but I am receiving “File not found” when I [...]
Answer Question
| December 23, 2010 7:28 AM
FTP, FTP management, FTP QTXTSRC data, iseries v5r4, V5R4
I previously sent this question around 2 A.M. est. This revised version should be more coherent. How do you send data in a QTXTSRC member via the IFS in order to FTP it from a dos prompt or in a CLP? I created a stream file but I am receiving “File not found” when I [...]
Answer Question
| December 23, 2010 7:28 AM
FTP, FTP management, FTP QTXTSRC data, iseries v5r4, V5R4
FTP from QTXTSRC
How do you data in a QTXTSRC member on the IFS in order to FTP it from a dos prompt or in a CLP? I created a stream file but I am receiving “File not found” when I run the get command.
Answer Question
| December 17, 2010 7:05 AM
FTP, FTP QTXTSRC data, IFS, IFS Commands, V5R4
How do you data in a QTXTSRC member on the IFS in order to FTP it from a dos prompt or in a CLP? I created a stream file but I am receiving “File not found” when I run the get command.
Answer Question
| December 17, 2010 7:05 AM
FTP, FTP QTXTSRC data, IFS, IFS Commands, V5R4
How do I know if an iSeries 9406-825 has the proper service processor?
How can I possibly know if an iSeries model 825 has proper service processor to support HMC?
Answer Question
| December 16, 2010 8:12 PM
AS/400, HMC, IBM iSeries 825, iSeries, V5R4
How can I possibly know if an iSeries model 825 has proper service processor to support HMC?
Answer Question
| December 16, 2010 8:12 PM
AS/400, HMC, IBM iSeries 825, iSeries, V5R4
Console command error
I am getting a error stating ” Unable to load frame’s content: B-tree structure is invalid” when trying to access a archive file. From what i can find i need to compact -d the file but when i run the command (load compact -d Filename) it fails staiting file cannot be found.The archive file is [...]
Answer Question
| December 16, 2010 3:11 PM
CMD, CMD Restriction, CMD Source
I am getting a error stating ” Unable to load frame’s content: B-tree structure is invalid” when trying to access a archive file. From what i can find i need to compact -d the file but when i run the command (load compact -d Filename) it fails staiting file cannot be found.The archive file is [...]
Answer Question
| December 16, 2010 3:11 PM
CMD, CMD Restriction, CMD Source
RPG III to RPG IV conversion
how to convert rpg iii code into rpg iv?
Answer Question
| December 21, 2010 8:50 AM
AS/400, RPG Programming, RPGILE
how to convert rpg iii code into rpg iv?
Answer Question
| December 21, 2010 8:50 AM
AS/400, RPG Programming, RPGILE
Automate iSeries Backup Checking using CLP
Hi there, I have created a CLP (I’m not really good at CL) that will run on request via scheduler after a backup has completed. It will check through the Hist Log looking for specific failure msgs. If it finds them it should email oncall support. Not sure if there is a better way to do [...]
Answer Question
| December 17, 2010 11:52 PM
AS/400, CLP, CLPROGRAM, DSPLOG, iSeries
Hi there, I have created a CLP (I’m not really good at CL) that will run on request via scheduler after a backup has completed. It will check through the Hist Log looking for specific failure msgs. If it finds them it should email oncall support. Not sure if there is a better way to do [...]
Answer Question
| December 17, 2010 11:52 PM
AS/400, CLP, CLPROGRAM, DSPLOG, iSeries
Keyboard lockup during AS/400 session
Why does my keyboard show “offline” at the bottom and lock up during an A/S 400 session?
Answer Question
| December 21, 2010 8:31 PM
AS/400 errors, AS/400 keyboards, AS/400 sessions
Why does my keyboard show “offline” at the bottom and lock up during an A/S 400 session?
Answer Question
| December 21, 2010 8:31 PM
AS/400 errors, AS/400 keyboards, AS/400 sessions
AS/400 file field usage
is there a way to determine what fields of a file are used in an RPG and CLP program?
Answer Question
| December 20, 2010 3:39 PM
AS/400 Fields, AS/400 file field usage, CLP, CLPROGRAM, RPG Program
is there a way to determine what fields of a file are used in an RPG and CLP program?
Answer Question
| December 20, 2010 3:39 PM
AS/400 Fields, AS/400 file field usage, CLP, CLPROGRAM, RPG Program
Using command cpytomimpf
I am trying to use the command…I have pf that I need to copy to the IFS directory pcfiles. I can ge the file copied but receive òðñð`ññ`ðñ�@@�ð÷ööôôó�ùð@@�@@�ñóöõöô÷…. Operation system is V5R4MO. Any ideas why the ebcdic to ascii is not working, If I use client access to export the file,it works fine, but wanting [...]
Answer Question
| December 16, 2010 4:35 AM
CPYTOIMPF, IFS Directory, IFS Directory to iSeries Folder, Physical Files, V5R4
I am trying to use the command…I have pf that I need to copy to the IFS directory pcfiles. I can ge the file copied but receive òðñð`ññ`ðñ�@@�ð÷ööôôó�ùð@@�@@�ñóöõöô÷…. Operation system is V5R4MO. Any ideas why the ebcdic to ascii is not working, If I use client access to export the file,it works fine, but wanting [...]
Answer Question
| December 16, 2010 4:35 AM
CPYTOIMPF, IFS Directory, IFS Directory to iSeries Folder, Physical Files, V5R4
Web message in AS/400 is stuck
There is a message in one of our inboxes that has been labeled as new and IN for the past year. We cannot read the message without the error: Job 440522/USERNAME/COLL18 started on 12/14/10 at 21:16:56 in subsystem QINT Permanent I/O error occurred in file WEB002D (C G D F). C CEE9901 received by WEB002RCL [...]
Answer Question
| December 17, 2010 2:59 AM
AS/400, AS/400 error messages, AS/400 errors, AS/400 message queues
There is a message in one of our inboxes that has been labeled as new and IN for the past year. We cannot read the message without the error: Job 440522/USERNAME/COLL18 started on 12/14/10 at 21:16:56 in subsystem QINT Permanent I/O error occurred in file WEB002D (C G D F). C CEE9901 received by WEB002RCL [...]
Answer Question
| December 17, 2010 2:59 AM
AS/400, AS/400 error messages, AS/400 errors, AS/400 message queues
Lock an OUTQ
How can you allocate an OUTQ for a user than deallocate.
Answer Question
| December 15, 2010 3:58 PM
Linux administration, OUTQ, OUTQ management, OUTQ security, Unix administration
How can you allocate an OUTQ for a user than deallocate.
Answer Question
| December 15, 2010 3:58 PM
Linux administration, OUTQ, OUTQ management, OUTQ security, Unix administration
CMD command on Windows 7
I want to know the command that can shows me the paths of destination to my computer IP in CMD on Windows 7? Can anyone can help me?
Answer Question
| May 17, 2013 9:58 AM
CMD, CMD Source, Windows 7
I want to know the command that can shows me the paths of destination to my computer IP in CMD on Windows 7? Can anyone can help me?
Answer Question
| May 17, 2013 9:58 AM
CMD, CMD Source, Windows 7
Advance technology next to optical libraries storing images iSeries
We use optical libraries (IBM and PLASMON) to store image documents,pdf’s, policy… . Which is the best advanced method to store these? Something like on platters, disc?? I read an article about virtual optical drives but not quite sure about it. Any help reg this
Answer Question
| December 14, 2010 7:56 AM
AS/400 hardware, iSeries Storage, Optical Drives, Optical storage
We use optical libraries (IBM and PLASMON) to store image documents,pdf’s, policy… . Which is the best advanced method to store these? Something like on platters, disc?? I read an article about virtual optical drives but not quite sure about it. Any help reg this
Answer Question
| December 14, 2010 7:56 AM
AS/400 hardware, iSeries Storage, Optical Drives, Optical storage
List objects owned by named user in iSeries
How can I list all objects on a system owned by named user. (I am trying to track where a certain user has made changes in the past (years ago..), and I want this to be part of the analysis. I would like to have a parameter ‘OWNER’ on the DSPOBJD command, but its not there. System [...]
Answer Question
| April 28, 2011 7:53 AM
DSPOBJD, IBM, Object authority, System i, V6R1
How can I list all objects on a system owned by named user. (I am trying to track where a certain user has made changes in the past (years ago..), and I want this to be part of the analysis. I would like to have a parameter ‘OWNER’ on the DSPOBJD command, but its not there. System [...]
Answer Question
| April 28, 2011 7:53 AM
DSPOBJD, IBM, Object authority, System i, V6R1
Using MGET FTP command
Does anyone know how may I get files with the same beginings as abc*.* in different directories inside of the main directory using mget. Any help would be appreciated
Answer Question
| December 14, 2010 2:38 AM
FTP, General Directories, MGET
Does anyone know how may I get files with the same beginings as abc*.* in different directories inside of the main directory using mget. Any help would be appreciated
Answer Question
| December 14, 2010 2:38 AM
FTP, General Directories, MGET
Colored CL Source
How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?
Answer Question
| April 9, 2012 10:00 PM
CL programming, CL programs, Programming Languages, SEU, SEU Editor
How do you insert a hexidecimal value in a CL program to change the color of the source using SEU?
Answer Question
| April 9, 2012 10:00 PM
CL programming, CL programs, Programming Languages, SEU, SEU Editor
