Synon - Maximum OR conditions in CASE Statement
Hi, My Synon program doesnt allows me to add more than 10 OR Conditions in one CASE Statement. C1 OR C2 OR C3 OR C4 OR C5 OR C6 OR C7 OR C8 OR C9 OR C10 OR C11 OR C12 OR C13. when given like above, it only generates the source for first 10 conditions. Remaining are ignore and even no error...
Hi, My Synon program doesnt allows me to add more than 10 OR Conditions in one CASE Statement. C1 OR C2 OR C3 OR C4 OR C5 OR C6 OR C7 OR C8 OR C9 OR C10 OR C11 OR C12 OR C13. when given like above, it only generates the source for first 10 conditions. Remaining are ignore and even no error...
10 pts.
AS400 Suddenly Out Of Space
I have an AS400 V5R1 that was at 60% and now over the weekend shot up to 99 % full. I have no ideas why I lost all the space. This happend last week as well and I removed an old library but still happening. Reclaim Storage and Splfiles Does Nothing. Is there a Journal that could have gone nuts ??...
I have an AS400 V5R1 that was at 60% and now over the weekend shot up to 99 % full. I have no ideas why I lost all the space. This happend last week as well and I removed an old library but still happening. Reclaim Storage and Splfiles Does Nothing. Is there a Journal that could have gone nuts ??...
Showcase Query 8.0 CDs or DVDs
I did an upgrade to V6R1 before I did an update to our Showcase Query Suite. I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any...
I did an upgrade to V6R1 before I did an update to our Showcase Query Suite. I am looking for a copy of the Showcase Query CD or DVD for Showcase Query Suite 8.0 released after September 2008. If anyone has this and would be willing to send me a copy please let me know. SPSS cannot ship any...
How to find out version of OS/400
How to find the version of OS/400 with out logon into the system? Like, if I dont have the System Id to logon, but I have the box.... How can I know it? Software/Hardware used: Iseries
How to find the version of OS/400 with out logon into the system? Like, if I dont have the System Id to logon, but I have the box.... How can I know it? Software/Hardware used: Iseries
Iam unable to view graph details of Performance data for more than one day.
I use GO PERFORM to view by graph of the cpu usage etc during the day. Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...
I use GO PERFORM to view by graph of the cpu usage etc during the day. Though i have configured the retention period for 15 days, i am able to view graph for data of the previous day only. Iam unable to view graph details of Performance data for data older than the previous days data. What do i...
9117-MMA Performance
WE have recently installed a 9117 MMA p570 which has 11 partitions, 3 of which are iSeries. All disk is on DS6800. Our performance has gone backwards on the Production iSeries partition, runtimes blown out excessively though I have seen some batch jobs running faster. We have heard thru the...
WE have recently installed a 9117 MMA p570 which has 11 partitions, 3 of which are iSeries. All disk is on DS6800. Our performance has gone backwards on the Production iSeries partition, runtimes blown out excessively though I have seen some batch jobs running faster. We have heard thru the...
AS/400 QUERY ; how can I calculate the month and year of 3 months ago in define result fields?
I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...
I am using an AS/400 query in which I need the month and year of 3 months ago based on today's date. To get today's date I use current(date) but I need to know the month/year 3 month ago and the month/year of previous month undepending which day of the current month it is. Is that possible? I...
Damaged Object unable to remove
Hi anyone else come across this problem. I have a damaged object which is causing the full system save backup to skip whe whole library with the damaged object in. The library is a user one with a object type of DSPF Normaly a delete and create a damaged object fixes all, but I can not...
Hi anyone else come across this problem. I have a damaged object which is causing the full system save backup to skip whe whole library with the damaged object in. The library is a user one with a object type of DSPF Normaly a delete and create a damaged object fixes all, but I can not...
System Upgrade Path Software and Hardware
We have a 170 box running V5R1. Which upgrade path is doable and or the best. Upgrade 170 with V5R1 to 270 running V5R2 Upgrade 170 with V5R1 to 270 running V5R4 Upgrade 170 with V5R1 to 525 LPAR running V5R4
We have a 170 box running V5R1. Which upgrade path is doable and or the best. Upgrade 170 with V5R1 to 270 running V5R2 Upgrade 170 with V5R1 to 270 running V5R4 Upgrade 170 with V5R1 to 525 LPAR running V5R4
Want to know the OS Installation date & Last OS Upgrade date..?
How can i trace the date when OS installed on my iSeries Server & When it is Last upgraded to newer version....? Software/Hardware used: IBM iSeries MMA (Power6)
How can i trace the date when OS installed on my iSeries Server & When it is Last upgraded to newer version....? Software/Hardware used: IBM iSeries MMA (Power6)
File Level Identifiers
If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?
If we save and restore SQL generated files which were created under an old OS/400 system software will the Format Level Identifier be changed and how does this affect the file?
We are runing V5R1 OS400, how do I write to CSV file
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.
We are trying to write a program that will take the output of a report, & put it on a CSV file. This file will the be sent via email to user(s). Please provide with steps to accomplish this including foldersetup, etc.
Use of Function Keys on OS/400 Command line
Can I set up a function key to enable a command to be run from the AS400 command line
Can I set up a function key to enable a command to be run from the AS400 command line
QAOSSS14B damaged object
During a recent full save prior to an OS upgrade, I noticed the object QAOSSS14B in QUSRSYS is damaged. Recovery is to delete and restore from backup. Problem, couldn't find it on a backup. Any other recovery? Thanks in advance. Sam Kentopian
During a recent full save prior to an OS upgrade, I noticed the object QAOSSS14B in QUSRSYS is damaged. Recovery is to delete and restore from backup. Problem, couldn't find it on a backup. Any other recovery? Thanks in advance. Sam Kentopian
Java on AS/400
Hi All,I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.
Hi All,I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.
JAVA and i5
Hi All, I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.
Hi All, I want to know what is the best configuration of i5 system to run JAVA application such as M3 ERP.
Display Query for OS/400 SQL script
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.
Is it possible to view the SQL that is generated by a query created in Query for OS/400. I have the query defined as I want it and would now like to give the SQL script to my development team to use in automating reports by accessing the database directly.
AS400 Disk space
AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP...
AS400 Disk space I’ve just inherited the responsibility for a couple of old AS400 (model 510, OS V4R5) which are out of support and although I spent many years supporting AS400 I’ve not touched them in the last 6 years and I have a little problem with them. The problem is the system ASP...
