COBOL/400
Hi Group, In COBOL/400 PGM the file has been declared with ACCESS as SEQUENTIAL and ORGANIZATION as SEQUENTIAL. How to delete a record from such file? Regards, M
Answer Question
| March 31, 2012 4:42 AM
COBOL, COBOL statements, COBOL/400, PGM
Hi Group, In COBOL/400 PGM the file has been declared with ACCESS as SEQUENTIAL and ORGANIZATION as SEQUENTIAL. How to delete a record from such file? Regards, M
Answer Question
| March 31, 2012 4:42 AM
COBOL, COBOL statements, COBOL/400, PGM
Update Data SQL Server From AS400
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.
Answer Question
| March 31, 2012 5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
Hi, some help me. I want to write data to SQL Server from AS400 in RPGLE. Some have code for make this. Thanks for advance.
Answer Question
| March 31, 2012 5:16 PM
AS/400 SQL, RPGLE, SQL Database, SQL Server
iSeries email mailrouter(*none)
I want to email notification of our daily backup result. Using the SNDDST command I can successfully send email to embarqmail.com, but not to aol.com (and possibly others). I am using the entries in the QZMF journal to see which emails are successful and which ones fail. What do I need to do so all [...]
Answer Question
| March 31, 2012 3:03 PM
AS/400, iSeries, SMTP, SNDDST
I want to email notification of our daily backup result. Using the SNDDST command I can successfully send email to embarqmail.com, but not to aol.com (and possibly others). I am using the entries in the QZMF journal to see which emails are successful and which ones fail. What do I need to do so all [...]
Answer Question
| March 31, 2012 3:03 PM
AS/400, iSeries, SMTP, SNDDST
AS/400 data transfer version 1.2 or 2.0
i have 2 different datatransfer files to get data from an AS/400 to excel. one is version 1.2 and the other has version 2.0 in the description what is the difference, cause i now got an other version of client access installed and the 1.2 version is not working anymore
Answer Question
| March 31, 2012 2:03 PM
AS/400 data transfer, Client Access Express, Exporting AS/400 to Excel
i have 2 different datatransfer files to get data from an AS/400 to excel. one is version 1.2 and the other has version 2.0 in the description what is the difference, cause i now got an other version of client access installed and the 1.2 version is not working anymore
Answer Question
| March 31, 2012 2:03 PM
AS/400 data transfer, Client Access Express, Exporting AS/400 to Excel
BRMS incremental Backup taking more time
Usually increamental backup using BRMS takes half hour where as the check point reaches in 4 or 5 mins….but last 3 days backup took more than 2 hours and check point reaches after one hour of delay, anyone pls suggest what would be the issue and how to resolve it?
Answer Question
| March 31, 2012 2:36 PM
Backup, BRMS, BRMS Backup, V5R4
Usually increamental backup using BRMS takes half hour where as the check point reaches in 4 or 5 mins….but last 3 days backup took more than 2 hours and check point reaches after one hour of delay, anyone pls suggest what would be the issue and how to resolve it?
Answer Question
| March 31, 2012 2:36 PM
Backup, BRMS, BRMS Backup, V5R4
ROBOT and BRMS
I need to know LOGIC using OPAL within ROBOT job Schedulerto validate if the BRMS console is active or not active before I can shut the systems down to perform a full system save.
Answer Question
| March 31, 2012 12:30 AM
AS/400 BRMS, AS400 Data Definitions, BRMS, ROBOT, Robot Job Scheduler
I need to know LOGIC using OPAL within ROBOT job Schedulerto validate if the BRMS console is active or not active before I can shut the systems down to perform a full system save.
Answer Question
| March 31, 2012 12:30 AM
AS/400 BRMS, AS400 Data Definitions, BRMS, ROBOT, Robot Job Scheduler
Way to restrict by user id, permissible libraries for WRKQRY
On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,
Answer Question
| March 31, 2012 3:55 PM
AS/400, AS/400 commands, AS/400 Library, OS/400, WRKQRY
On OS400, Is there a way to manage limitation for permissible librairies when they use the command WRKQRY? And for those limited librairies can we assign a limit or quota to the storage usage per user id ou user group to avoid creation of enourmous files? Thanks in advance for reply on that,
Answer Question
| March 31, 2012 3:55 PM
AS/400, AS/400 commands, AS/400 Library, OS/400, WRKQRY
JDBC connection thru AS/400
Hi All we are getting issue in as400 cpu utilisation. qzdasoinit jobs is getting killed after closing connection but after when we initiate a fresh connection it utlises cpu from where previous connection was closed. Suppose if previous connection was closed at cpu usage 10%, job would disappear from wrkactjob but when fresh connection is [...]
Answer Question
| March 31, 2012 3:34 PM
AS/400 jobs, CPU Utilization, JDBC, WRKACTJOB
Hi All we are getting issue in as400 cpu utilisation. qzdasoinit jobs is getting killed after closing connection but after when we initiate a fresh connection it utlises cpu from where previous connection was closed. Suppose if previous connection was closed at cpu usage 10%, job would disappear from wrkactjob but when fresh connection is [...]
Answer Question
| March 31, 2012 3:34 PM
AS/400 jobs, CPU Utilization, JDBC, WRKACTJOB
Open IT Forum: What to consider when building a data center?
What are some of the key factors the enterprise should consider when building a data center that can last? We’d love to hear stories from your own experience, or see lists of your own must-haves when it comes to a new data center. Share your thoughts and we’ll share 100 Knowledge Points!
Answer Question
| March 31, 2012 2:18 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What are some of the key factors the enterprise should consider when building a data center that can last? We’d love to hear stories from your own experience, or see lists of your own must-haves when it comes to a new data center. Share your thoughts and we’ll share 100 Knowledge Points!
Answer Question
| March 31, 2012 2:18 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Data Center Build, Data center design and infrastructure, Data Center management, Database, DataCenter, Development, Exchange, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS400 Query: Date Concatenation
I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily [...]
Answer Question
| March 31, 2012 9:20 PM
AS/400, AS/400 Query, AS/400 Records, Date concatenation
I work for a travel company whose Inventory file uses a unique field for each day of the month, e.g. LGRA1 is the first, LGRA2 is the second etc. The month and the year are single fields. Is there a way of converting these fields to concatenate the date to be able to link easily [...]
Answer Question
| March 31, 2012 9:20 PM
AS/400, AS/400 Query, AS/400 Records, Date concatenation
Record Locking in Access 2007
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?
Answer Question
| March 31, 2012 8:48 PM
Access 2007, Access Database, Record lock, User Interface
How can I lock records in a simple Access database after updates? And, how do I set up the user interface to include only the form I would like for the user to complete?
Answer Question
| March 31, 2012 8:48 PM
Access 2007, Access Database, Record lock, User Interface
Various Ethline failures
We have moved 15 of 20 AS400 / iSeries to a new business DMZ. The five systems that fail range from OS level V4R5M0 to V5R4M0 and system types 50S to 520. Some failed systems are LPARs where half the systems of the LPAR are functioning with their new IPs while the other half fail. [...]
Answer Question
| March 31, 2012 8:27 PM
DMZ, Ethernet, STRTCP, TCP/IP, V4R5M0
We have moved 15 of 20 AS400 / iSeries to a new business DMZ. The five systems that fail range from OS level V4R5M0 to V5R4M0 and system types 50S to 520. Some failed systems are LPARs where half the systems of the LPAR are functioning with their new IPs while the other half fail. [...]
Answer Question
| March 31, 2012 8:27 PM
DMZ, Ethernet, STRTCP, TCP/IP, V4R5M0
Creating an overlay for v6.1
We are converting to an iSeries v6.1 and want to eliminate our track-feed printers. We have been told we can create overlays in Microsoft Publisher and have this “merge” with the spool file (invoices, purchase order, etc). I need step by step instructions in how to set this up. Your help is greatly appreciated.
Answer Question
| March 31, 2012 5:38 PM
iSeries printing, iSeries V6R1, V6R1
We are converting to an iSeries v6.1 and want to eliminate our track-feed printers. We have been told we can create overlays in Microsoft Publisher and have this “merge” with the spool file (invoices, purchase order, etc). I need step by step instructions in how to set this up. Your help is greatly appreciated.
Answer Question
| March 31, 2012 5:38 PM
iSeries printing, iSeries V6R1, V6R1
Data Compression with Remote Journal
Is there a way to apply some sort of data compression (remove repetitive blanks) with a remote journal. These journal entries are for records added to a databse file containing a single 32K long field.
Answer Question
| March 31, 2012 2:54 PM
Data compression, Remote journaling, V5R4
Is there a way to apply some sort of data compression (remove repetitive blanks) with a remote journal. These journal entries are for records added to a databse file containing a single 32K long field.
Answer Question
| March 31, 2012 2:54 PM
Data compression, Remote journaling, V5R4
Free IT Book: The Official Ubuntu Book
Take full advantage of Ubuntu – the complete, free operating system “that emphasizes community, support, and ease of use without compromising speed, power, or flexibility” – by winning this week’s free IT book: The Official Ubuntu Book, 6th Ed. Answer one of five questions and post the link to your answer in the discussion area [...]
Answer Question
| March 31, 2012 1:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Ubuntu, Virtualization, VoIP, Windows Server
Take full advantage of Ubuntu – the complete, free operating system “that emphasizes community, support, and ease of use without compromising speed, power, or flexibility” – by winning this week’s free IT book: The Official Ubuntu Book, 6th Ed. Answer one of five questions and post the link to your answer in the discussion area [...]
Answer Question
| March 31, 2012 1:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Ubuntu, Virtualization, VoIP, Windows Server
* CPF6412 – compilation error
When I compile my cobol cbl program , i get this strange error. . EXCKRD5F 1 >8X ” X ” N . EXCKRDAF 1 ? X ” X ” X à MSGID MI Instruction Stream Semantic Diagnostics * CPF6412 Attributes of instruction X’56F9′ operand 1 not valid. Probable compiler error. * CPF6412 Attributes of instruction [...]
Answer Question
| March 31, 2012 10:01 AM
COBOL, COBOL Programs, COBOL/400
When I compile my cobol cbl program , i get this strange error. . EXCKRD5F 1 >8X ” X ” N . EXCKRDAF 1 ? X ” X ” X à MSGID MI Instruction Stream Semantic Diagnostics * CPF6412 Attributes of instruction X’56F9′ operand 1 not valid. Probable compiler error. * CPF6412 Attributes of instruction [...]
Answer Question
| March 31, 2012 10:01 AM
COBOL, COBOL Programs, COBOL/400
How to replace the batch query in QMF thru JCL?
i have one batch query in DBC4MED1.BR211Q_SALEANAL(PRODUCTION).. this batch query is running thru the QMF PROC DBC4MED1.BR211P_SALEANAL to create a report. now i have made changes to the batch query and saved with my HLQ (PM7351.BR21Q_SALEANAL) in QMF.Now i want to repace the query in DBC4MED1.BR211Q_SALEANAL with the modified query which was there in my HLQ [...]
Answer Question
| March 31, 2012 5:56 AM
AS/400 batch jobs, JCL, Mainframe jobs( JCL, QMF, QMF Objects
i have one batch query in DBC4MED1.BR211Q_SALEANAL(PRODUCTION).. this batch query is running thru the QMF PROC DBC4MED1.BR211P_SALEANAL to create a report. now i have made changes to the batch query and saved with my HLQ (PM7351.BR21Q_SALEANAL) in QMF.Now i want to repace the query in DBC4MED1.BR211Q_SALEANAL with the modified query which was there in my HLQ [...]
Answer Question
| March 31, 2012 5:56 AM
AS/400 batch jobs, JCL, Mainframe jobs( JCL, QMF, QMF Objects
What are the steps needs to be followed while removing Key Fields from PF.
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]
Answer Question
| March 31, 2012 5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]
Answer Question
| March 31, 2012 5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files
How to avoid the system message displaying on display screen.
System message is displaying at 24th lin eof display screen but I dont want to display the message over there. Please let me know to avoid this.
Answer Question
| March 31, 2012 10:06 PM
AS/400, AS/400 Display File, AS/400 performance
System message is displaying at 24th lin eof display screen but I dont want to display the message over there. Please let me know to avoid this.
Answer Question
| March 31, 2012 10:06 PM
AS/400, AS/400 Display File, AS/400 performance
SSH Orphaned Qinter Sessions
We are in the process of rolling out SSH on all our Lpars and we are testing and poking around and have found a number of occassions where we have an Orphaned Qinter Job associated with a SSH or Qshell job. These jobs have been running for days and days, not sure why the Inactivity [...]
Answer Question
| March 31, 2012 8:54 PM
LPAR Configuration, QINTER, SSH, SSH Configuration
We are in the process of rolling out SSH on all our Lpars and we are testing and poking around and have found a number of occassions where we have an Orphaned Qinter Job associated with a SSH or Qshell job. These jobs have been running for days and days, not sure why the Inactivity [...]
Answer Question
| March 31, 2012 8:54 PM
LPAR Configuration, QINTER, SSH, SSH Configuration
