Certificate not signed by trusted authority
We have been been communicating with Twitter from our iSeries. Recently Twitter increased their security and now required a digital certificate. We followed all the setup instructions but get this error on the green screen. gsk_secure_soc_init() failed with rc = 6000 and errno = 0. 8 rc of 6000 means Certificate is not signed by [...]
Answer Question
| May 6, 2011 11:39 PM
Certificate authorities, Certificate authority, Digital certificates, iSeries, iSeries communication, twitter
We have been been communicating with Twitter from our iSeries. Recently Twitter increased their security and now required a digital certificate. We followed all the setup instructions but get this error on the green screen. gsk_secure_soc_init() failed with rc = 6000 and errno = 0. 8 rc of 6000 means Certificate is not signed by [...]
Answer Question
| May 6, 2011 11:39 PM
Certificate authorities, Certificate authority, Digital certificates, iSeries, iSeries communication, twitter
SQL RPGLE – How to override data set data structure at run time
I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to [...]
Answer Question
| September 23, 2010 1:43 PM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE
I currently have an SQL RPGLE routine that receives a SELECT statement as a parameter and then fetches the data set into a data structure based on the file. This only works over a single file as the datastructure is created at compile time and has to be based on filea. I would like to [...]
Answer Question
| September 23, 2010 1:43 PM
iSeries, RPGLE, SELECT statement, SQL, SQL Select statement problem, SQLRPGLE
Identifying special characters when creating XML output
Hi Everyone, I’m in the process of creating xml files (using RPGLE) to send order details to our clients. One requirement is the need to replace (encode) special characters such as < > ‘”& No problem there, my scan can identify and replace where necessary. The problem arises with characters not native to IBM such [...]
Answer Question
| September 23, 2010 11:30 AM
iSeries, RPGLE Program, XML, XML development, XML File Creation
Hi Everyone, I’m in the process of creating xml files (using RPGLE) to send order details to our clients. One requirement is the need to replace (encode) special characters such as < > ‘”& No problem there, my scan can identify and replace where necessary. The problem arises with characters not native to IBM such [...]
Answer Question
| September 23, 2010 11:30 AM
iSeries, RPGLE Program, XML, XML development, XML File Creation
RPG/400 Trigger Program
RPG/400 trigger program was suggested to develop a moving average computation. There’s a rule that needs to be followed when posting a record in the computation. One rule is that all credit transactions be first posted in the computation – Is this possible in a trigger program? How could I implement this rule?
Answer Question
| September 23, 2010 1:02 PM
AS/400, AS/400 triggers, iSeries, RPG/400
RPG/400 trigger program was suggested to develop a moving average computation. There’s a rule that needs to be followed when posting a record in the computation. One rule is that all credit transactions be first posted in the computation – Is this possible in a trigger program? How could I implement this rule?
Answer Question
| September 23, 2010 1:02 PM
AS/400, AS/400 triggers, iSeries, RPG/400
Using SELECT with LIMIT clause on a physical file
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.
Answer Question
| September 24, 2010 1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
Hi – I’m new to PHP & SQL and wanted to know if you can use mysql SELECT with the LIMIT clause on a iseries physical file in order to do pagination. Thanks for the help.
Answer Question
| September 24, 2010 1:18 PM
iSeries, MySQL, Oracle SQL Pagination, Pagination, SQL Select
Tape availability in AS/400
I have tapes in the library that are “inserted” how do i make them “avaiable” for backup?
Answer Question
| September 20, 2010 11:24 PM
AS/400, Backup, iSeries, iSeries backup, iSeries backup and recovery, Tape Backups
I have tapes in the library that are “inserted” how do i make them “avaiable” for backup?
Answer Question
| September 20, 2010 11:24 PM
AS/400, Backup, iSeries, iSeries backup, iSeries backup and recovery, Tape Backups
get an i-Series *LIBL in a .NET program
I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started looking into [...]
Answer Question
| September 7, 2010 4:37 PM
.NET, AS/400, iSeries, LIBL, RPGILE
I have a .NET programmer asking how he can get the i-Series *LIBL. Based on how the connection is established we can run under 6 different environments. A production and a test for 3 different locations. These are all running on the same i-Series machine. Any ideas or pointers? I have just started looking into [...]
Answer Question
| September 7, 2010 4:37 PM
.NET, AS/400, iSeries, LIBL, RPGILE
FTP PUT command adding an extra (carriage return?) character
I have a physical file on the iSeries which I am sending to a Windows server. When the file gets to the server, an extra line has been added with what is (I think) an end of file or carriage return character. The software that is processing the file on the server doesn’t handle this [...]
Answer Question
| September 3, 2010 6:20 PM
AS/400, FTP, iSeries, Physical Files
I have a physical file on the iSeries which I am sending to a Windows server. When the file gets to the server, an extra line has been added with what is (I think) an end of file or carriage return character. The software that is processing the file on the server doesn’t handle this [...]
Answer Question
| September 3, 2010 6:20 PM
AS/400, FTP, iSeries, Physical Files
iSeries spool file to Livelink
How can i extract an iSeries spool file into Livelink?
Answer Question
| September 8, 2010 3:49 PM
AS/400 Spool Files, iSeries, Livelink, OpenText LiveLink, Spool File to PDF, Spool files
How can i extract an iSeries spool file into Livelink?
Answer Question
| September 8, 2010 3:49 PM
AS/400 Spool Files, iSeries, Livelink, OpenText LiveLink, Spool File to PDF, Spool files
Can a Display File be used in an RPGLE program running in batch?
I would like to convert an interactive RPGLE program to run in batch mode and would like to keep from replacing the display file in the batch version. Like the interactive version, the batch version would have to write/update and read each of the 3 subfiles in the display file, but would use no WRITE’s [...]
Answer Question
| September 2, 2010 9:01 PM
Display File, iSeries, RPGLE, V5R4
I would like to convert an interactive RPGLE program to run in batch mode and would like to keep from replacing the display file in the batch version. Like the interactive version, the batch version would have to write/update and read each of the 3 subfiles in the display file, but would use no WRITE’s [...]
Answer Question
| September 2, 2010 9:01 PM
Display File, iSeries, RPGLE, V5R4
CPTYTOSTMF problem
I am getting error in cpytostmf command while getting the member to ifs folder which is object is not a file or is a file with attributes not supported by this command. object not copied /QSYS.LIB/LIBRARY.LIB/FILENAME.FILE/MBRNAME.MBR
Answer Question
| September 2, 2010 7:28 AM
CPYTOSTMF, iSeries, iSeries Commands, QSYS, QSYS.LIB
I am getting error in cpytostmf command while getting the member to ifs folder which is object is not a file or is a file with attributes not supported by this command. object not copied /QSYS.LIB/LIBRARY.LIB/FILENAME.FILE/MBRNAME.MBR
Answer Question
| September 2, 2010 7:28 AM
CPYTOSTMF, iSeries, iSeries Commands, QSYS, QSYS.LIB
Using CTE with Update on the iSeries
Anyone have examples of using a common table expression with an update of fields in a file?
Answer Question
| September 7, 2010 8:30 PM
AS/400 SQL, iSeries, iSeries AS/400
Anyone have examples of using a common table expression with an update of fields in a file?
Answer Question
| September 7, 2010 8:30 PM
AS/400 SQL, iSeries, iSeries AS/400
created a test profile with only *JOBCTL authority; unable to type WRKJOBSCDE
Hi all, I created a test profile with only *JOBCTL authority. I was unable to type command WRKJOBSCDE & ADDJOBSCDE, but I was able to CHGJOBSCDE, DELJOBSCDE & HLDJOBSCDE. Wanted to know what did I set wrongly, please help, thanks. User Profile : TEST User class : *USER Special authority : *JOBCTL Group profile : [...]
Answer Question
| September 2, 2010 3:53 AM
AS/400, AS/400 Authorization List, iSeries, WRKJOBSCDE
Hi all, I created a test profile with only *JOBCTL authority. I was unable to type command WRKJOBSCDE & ADDJOBSCDE, but I was able to CHGJOBSCDE, DELJOBSCDE & HLDJOBSCDE. Wanted to know what did I set wrongly, please help, thanks. User Profile : TEST User class : *USER Special authority : *JOBCTL Group profile : [...]
Answer Question
| September 2, 2010 3:53 AM
AS/400, AS/400 Authorization List, iSeries, WRKJOBSCDE
What causes a CPF9076 Internal system error pocessing documents or folders
We have received this message CPF9076 Internal system error pocessing documents or folders intermittently when copying a document to a folder. I have tried to find out why but have been unsuccessful in my searches. Does anyone have any ideas. Thanks
Answer Question
| August 31, 2010 3:47 PM
CPF9076, Document processing, i515, iSeries
We have received this message CPF9076 Internal system error pocessing documents or folders intermittently when copying a document to a folder. I have tried to find out why but have been unsuccessful in my searches. Does anyone have any ideas. Thanks
Answer Question
| August 31, 2010 3:47 PM
CPF9076, Document processing, i515, iSeries
EBCDIC Database File Problem
My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special characters. What I’m attempting to [...]
Answer Question
| December 2, 2010 3:28 PM
AS/400 Database File, AS400 Data Definitions;database, COBOL, Database Files, EBCDIC, FTP, iSeries
My company received a file supposedly in EBCDIC format. We copied it to the shared network drive and attempted to FTP it several different times using several different types. The file transferred but when displaying it the records were all variable length and appears to have CR or EOL special characters. What I’m attempting to [...]
Answer Question
| December 2, 2010 3:28 PM
AS/400 Database File, AS400 Data Definitions;database, COBOL, Database Files, EBCDIC, FTP, iSeries
Is it posssible to get a list of program objects which run with adopted authority
Is it posssible to get a list of program objects which run with adopted authority
Answer Question
| August 26, 2010 11:14 AM
AS/400, AS/400 objects, iSeries, iSeries AS/400
Is it posssible to get a list of program objects which run with adopted authority
Answer Question
| August 26, 2010 11:14 AM
AS/400, AS/400 objects, iSeries, iSeries AS/400
How can you see the records in the new i 515 series?
In the old s36 enviroment, when ou browse your files,I could see the records of each file simultanuosly by pressing F10. In the new I515 series, i still haven’t found the right command to see the records in wrkobjpdm. It’s annoying to type 12 and than 5 for each file seperately. Like in the old [...]
Answer Question
| August 30, 2010 1:37 PM
i515, iSeries, iSeries Commands
In the old s36 enviroment, when ou browse your files,I could see the records of each file simultanuosly by pressing F10. In the new I515 series, i still haven’t found the right command to see the records in wrkobjpdm. It’s annoying to type 12 and than 5 for each file seperately. Like in the old [...]
Answer Question
| August 30, 2010 1:37 PM
i515, iSeries, iSeries Commands
How to upload (SAVF) file from Windows to iSeries (SAVF)
Hi, I’ve a file MFUTL.SAVF under windows desktop, and I want to upload this file to iSeries as SAVF. 1. Why can’t I just used drag and drop under iNavigator? 2. FTP from Windows to iSeries, how to define the Source system? 3. How do i go about uploading? Kindly help.
Answer Question
| August 27, 2010 4:38 AM
FTP, iNavigator, iSeries, iSeries v5, SAVF, Windows
Hi, I’ve a file MFUTL.SAVF under windows desktop, and I want to upload this file to iSeries as SAVF. 1. Why can’t I just used drag and drop under iNavigator? 2. FTP from Windows to iSeries, how to define the Source system? 3. How do i go about uploading? Kindly help.
Answer Question
| August 27, 2010 4:38 AM
FTP, iNavigator, iSeries, iSeries v5, SAVF, Windows
TSM error – Object could not be sent to TSM server
We use TSM Client V5.5 on our iSeries systems to do backups to a TSM server. We have a number of weekly saves that don’t always complete successfully. The TSM error code is 157. I have contacted our TSM Server support group but they never see anything in the logs on the TSM server that would explain [...]
Answer Question
| November 23, 2010 2:45 PM
Backup, iSeries, iSeries backup, TSM, TSM Backup
We use TSM Client V5.5 on our iSeries systems to do backups to a TSM server. We have a number of weekly saves that don’t always complete successfully. The TSM error code is 157. I have contacted our TSM Server support group but they never see anything in the logs on the TSM server that would explain [...]
Answer Question
| November 23, 2010 2:45 PM
Backup, iSeries, iSeries backup, TSM, TSM Backup
List of IBM midrange servers
Is there a document, listing all midrange servers from IBM? Are pSeries Server included in this category? Thank You!
Answer Question
| August 24, 2010 1:44 PM
AS/400, IBM Servers, iSeries, pSeries, RS/6000
Is there a document, listing all midrange servers from IBM? Are pSeries Server included in this category? Thank You!
Answer Question
| August 24, 2010 1:44 PM
AS/400, IBM Servers, iSeries, pSeries, RS/6000
