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 ??...
data search using popup window
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF? Software/Hardware used: RPG, CL, SQL, iSeries
Is there a sample RPG/CL/SQL code on how to create a popup window to search data from a PF? Software/Hardware used: RPG, CL, SQL, iSeries
A need for more than one mail journaling database
Is it possible to setup more than one mail journaling database on the same Domino 8.5 server? We need to collect a lot of incoming and outgoing messages for litigation purposes, and we are currently collecting all in one journalin Db. It would be nice to be able to have individual databases for...
Is it possible to setup more than one mail journaling database on the same Domino 8.5 server? We need to collect a lot of incoming and outgoing messages for litigation purposes, and we are currently collecting all in one journalin Db. It would be nice to be able to have individual databases for...
Job type change
Can one change the type of the job(from batch to interactive or viceversa) when that job is running. If possible plz explain the process. thx Software/Hardware used: as/400, V5R4
Can one change the type of the job(from batch to interactive or viceversa) when that job is running. If possible plz explain the process. thx Software/Hardware used: as/400, V5R4
AS/400 classes
Hi, what is a class on AS/400 system and where are they used. How is it created and its significance? thanks Software/Hardware used: as/400, V5R4
Hi, what is a class on AS/400 system and where are they used. How is it created and its significance? thanks Software/Hardware used: as/400, V5R4
OVRDBF AT DIFFERENT CALL LEVELS
HI , I am using the command ovrdbf file(file1) tofile(file2) in the CL program and i am calling an RPG program again in that i want to override the same file(file2) to different members(using qcmdexe). how to do that?
HI , I am using the command ovrdbf file(file1) tofile(file2) in the CL program and i am calling an RPG program again in that i want to override the same file(file2) to different members(using qcmdexe). how to do that?
Retriveing massage from submited job in CLP
I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go...
I have CLP and a cobol program. CL program calls the cobol program in Batch mode by doing SBMJOB. The cobol program processing 1000 records from a database file. If it founds errorneous record in the time of processing, then it stops processing with a system generated error massage and control go...
Websphere V6
When I tried to install Websphere MQ V6.0 To iSeries 9406-270 running OS/400 V5R3M0 the following massage appear *PGM Object for product 5724H72 option *BASE release *First not found on DEV(OPT01)
When I tried to install Websphere MQ V6.0 To iSeries 9406-270 running OS/400 V5R3M0 the following massage appear *PGM Object for product 5724H72 option *BASE release *First not found on DEV(OPT01)
ASP
I have AS/400 9406-270 with expansion unit 12 H.D.(4318)connected to 2763 IBM PCI RAID Disk Unit Controller assigned as ASP1.(175GB with ASP %91) I added six 4318 H.D.(to decrease the percentage)and connected them as parity to second 2763 IBM PCI RAID Disk Unit Controller and I assigned them as...
I have AS/400 9406-270 with expansion unit 12 H.D.(4318)connected to 2763 IBM PCI RAID Disk Unit Controller assigned as ASP1.(175GB with ASP %91) I added six 4318 H.D.(to decrease the percentage)and connected them as parity to second 2763 IBM PCI RAID Disk Unit Controller and I assigned them as...
Data Extaction and Cleansing as/400
What is the best way to extract and clean data from AS/400 dbase? We are planning to replace legacy systems with an integrated package that may have a different dbase. Is there a good product / service? Software/Hardware used: as/400
What is the best way to extract and clean data from AS/400 dbase? We are planning to replace legacy systems with an integrated package that may have a different dbase. Is there a good product / service? Software/Hardware used: as/400
PCI scan indicates finding default Apache directories on IBM System I5
Scan indicates find default Apache directories such as /_borders/ /_overlay/ /_themes/ /banners/ ... Does anyone know where these Apache directories exist and/or how to stop access on IBM System I5. This is a low threat item but is only thing keeping me from 100% clean scan? Software/Hardware...
Scan indicates find default Apache directories such as /_borders/ /_overlay/ /_themes/ /banners/ ... Does anyone know where these Apache directories exist and/or how to stop access on IBM System I5. This is a low threat item but is only thing keeping me from 100% clean scan? Software/Hardware...
AS/400 FTP error- TCP3D2C Secure connection error, return code -24
I am trying to FTP from Backup AS/400 box to our Production AS/400 box or visa versa and I get the following error when trying to transfer a file of any significant size(larger than 1Kb): Software/Hardware used: AS/400, AS/400 FTP
I am trying to FTP from Backup AS/400 box to our Production AS/400 box or visa versa and I get the following error when trying to transfer a file of any significant size(larger than 1Kb): Software/Hardware used: AS/400, AS/400 FTP
Notes agent accessing attachment from IFS on another iSeries
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with...
I have a domino server running on an iSeries(Ranger). Through a scheduled agent I am trying to put an attachment from a different iSeries (Raven) in a notes document. I am having difficulties with this. When the IFS was local (on the same iSeries) it was easy, just point to the directory with...
IP address clarification -- different IP addresses for same computer - ipconfig vs. browser
This question is just for my own education (as opposed to trying to accomplish a particular task). Can someone explain the difference between the IP address which is displayed by sites, such as: http://www.displayip.net/ - as your computer's IP address and the information that ipconfig...
This question is just for my own education (as opposed to trying to accomplish a particular task). Can someone explain the difference between the IP address which is displayed by sites, such as: http://www.displayip.net/ - as your computer's IP address and the information that ipconfig...
Auditing an AS/400 Server
Hi Gilly400: please, is there any way to know who viewed or accessed my spoolfile???????
Hi Gilly400: please, is there any way to know who viewed or accessed my spoolfile???????
Downloading Files Using Client Access In CSV Formats
I am downloading a data file using Client Access. I would like to create the file in the CSV format is there a to include the column headings in the data file? Software/Hardware used: iSeries 520 - Clint Access Version 5.8
I am downloading a data file using Client Access. I would like to create the file in the CSV format is there a to include the column headings in the data file? Software/Hardware used: iSeries 520 - Clint Access Version 5.8
The IT Blog Top 10: Nov. 12, 2009
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
10. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees offers up an indispensible guide for VBScripters. 9. Standard Server 2003 Migration to SBS 2008 Part 3 Roger Crawford’s third part of his series on Server 2003 migrations. 8. Success of 64-bit Internet...
Record Locking
I'm using embeded SQL to delete (clear) all records in a file. I do not want more than 1 person in this file. So whe the user executes the program it runs the SQL and clears the records in the file. Now I want to do some file/record checking logic to see if the file is locked to another job. THen...
I'm using embeded SQL to delete (clear) all records in a file. I do not want more than 1 person in this file. So whe the user executes the program it runs the SQL and clears the records in the file. Now I want to do some file/record checking logic to see if the file is locked to another job. THen...
