AS/400 Triggers – Writing a trigger for a file
Here’s a recent discussion that should help. ————- 09/01/09 Didn’t read your question closely enough. You trigger on add/update/delete not commit. The add/update/delete makes the file changes but keeps the records locked The Commit releases the locks and moves the boundry in the journal but doesn’t fire a trigger. On the other hand, you could [...]
View Answer
| June 18, 2013 1:28 PM
as400/DB2 - Trigger - Comit
Here’s a recent discussion that should help. ————- 09/01/09 Didn’t read your question closely enough. You trigger on add/update/delete not commit. The add/update/delete makes the file changes but keeps the records locked The Commit releases the locks and moves the boundry in the journal but doesn’t fire a trigger. On the other hand, you could [...]
View Answer
| June 18, 2013 1:28 PM
as400/DB2 - Trigger - Comit
AS/400 Triggers: Batch programs don’t write to trigger file
When you did the ADDPFTRG, you specified what program gets called when action is done to the file. The call the this program will have regardless of how the files is updated (Batch or Interactive). So I am suspecting that the problem is in your trigger program. Can you show us the code?
View Answer
| June 18, 2013 8:08 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure
When you did the ADDPFTRG, you specified what program gets called when action is done to the file. The call the this program will have regardless of how the files is updated (Batch or Interactive). So I am suspecting that the problem is in your trigger program. Can you show us the code?
View Answer
| June 18, 2013 8:08 PM
AS/400 administration, AS/400 Parameters, AS/400 triggers, CL batch program, TRIGGER, Trigger failure
OUTQ: Separate spool files
Hi, You can change the default OUTQ for a particular user by using CHGUSRPRF Command. <pre>CHGUSRPRF USERNAM</pre> Take F10(Additional Parameters) and You will find an option for having OUTQ. <pre> Change User Profile (CHGUSRPRF) Type choices, press Enter. Group profile . . . . . . . . . GRPPRF > DEVGRP Owner . . [...]
View Answer
| June 18, 2013 8:24 AM
AS/400 OUTQ
Hi, You can change the default OUTQ for a particular user by using CHGUSRPRF Command. <pre>CHGUSRPRF USERNAM</pre> Take F10(Additional Parameters) and You will find an option for having OUTQ. <pre> Change User Profile (CHGUSRPRF) Type choices, press Enter. Group profile . . . . . . . . . GRPPRF > DEVGRP Owner . . [...]
View Answer
| June 18, 2013 8:24 AM
AS/400 OUTQ
OUTQ: Move PF file to SPLF or printer
You can use RUNQRY command for writing the PF to Printer. You will need to select Report Output type as <b>*Printer</b> <pre>Report output type . . . . . . . > *PRINTER *RUNOPT, *DISPLAY… </pre> Pradeep.
View Answer
| June 18, 2013 5:16 AM
as400 pf file
You can use RUNQRY command for writing the PF to Printer. You will need to select Report Output type as <b>*Printer</b> <pre>Report output type . . . . . . . > *PRINTER *RUNOPT, *DISPLAY… </pre> Pradeep.
View Answer
| June 18, 2013 5:16 AM
as400 pf file
Run time error when OPNQRY is executed
OK here’s a shot. because APGLDT is numeric you don’t need the ” ” around the data to be compared &POST is of char type but as long as it looks like a number when the string is built it should work fine. OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT(‘APGLDT *EQ ‘ *CAT &POST + *CAT [...]
View Answer
| June 18, 2013 5:57 PM
APGLDT, APINDVT, AS/400 error messages, AS/400 Runtime Errors, OPNQRY
OK here’s a shot. because APGLDT is numeric you don’t need the ” ” around the data to be compared &POST is of char type but as long as it looks like a number when the string is built it should work fine. OPNQRYF FILE((*LIBL/APH *FIRST *ONLY)) + QRYSLT(‘APGLDT *EQ ‘ *CAT &POST + *CAT [...]
View Answer
| June 18, 2013 5:57 PM
APGLDT, APINDVT, AS/400 error messages, AS/400 Runtime Errors, OPNQRY
Problem with the syntax of OPNQRY command
The query select is processed twice – once by CL – processing your string commands then by the database manager. When this string is processed by CL ‘APCMPY *EQ ”*CAT XPCMP *CAT”’ It gets. APCMPY *EQ ‘ *CAT XPCMP *CAT’ But thats not what the query processor needs which would look like this – if [...]
View Answer
| June 18, 2013 4:47 PM
OPNQRY, OPNQRYF, QRYSLT, RCVF
The query select is processed twice – once by CL – processing your string commands then by the database manager. When this string is processed by CL ‘APCMPY *EQ ”*CAT XPCMP *CAT”’ It gets. APCMPY *EQ ‘ *CAT XPCMP *CAT’ But thats not what the query processor needs which would look like this – if [...]
View Answer
| June 18, 2013 4:47 PM
OPNQRY, OPNQRYF, QRYSLT, RCVF
iSeries Navigator isn’t working on my new laptop
Which version of iSeries Access have you got installed on your laptop? Also which service pack have you got loaded.
View Answer
| June 18, 2013 7:01 AM
PC/Windows Connectivity
Which version of iSeries Access have you got installed on your laptop? Also which service pack have you got loaded.
View Answer
| June 18, 2013 7:01 AM
PC/Windows Connectivity
iSeries navigator error message
If you have the rights and competence to do that, uninstalling Client Access, rebooting and reinstalling the package should fix the problem. Note from Don: I have run into the error after a hardware refresh. The issue was the PC’s had version V5R3 Client Access loaded as well as V5R4 iNav. When you uninstall, make [...]
View Answer
| June 18, 2013 5:38 PM
iSeries, iSeries Navigator, V5R3
If you have the rights and competence to do that, uninstalling Client Access, rebooting and reinstalling the package should fix the problem. Note from Don: I have run into the error after a hardware refresh. The issue was the PC’s had version V5R3 Client Access loaded as well as V5R4 iNav. When you uninstall, make [...]
View Answer
| June 18, 2013 5:38 PM
iSeries, iSeries Navigator, V5R3
ORA-12535 error on Oracle 9i
Good morning. Have you checked your sqlnet.log files on the remote systems? Any errors encountered during connections should be logged there. Also, have you turned on tracing? This could also help diagnose the problem. One last question: Has anything changed in your environment (network, Oracle upgrades, DNS routing) which could potentially impact this? I hope [...]
View Answer
| June 18, 2013 7:14 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
Good morning. Have you checked your sqlnet.log files on the remote systems? Any errors encountered during connections should be logged there. Also, have you turned on tracing? This could also help diagnose the problem. One last question: Has anything changed in your environment (network, Oracle upgrades, DNS routing) which could potentially impact this? I hope [...]
View Answer
| June 18, 2013 7:14 AM
Architecture/Design, Availability, Data/Application Integration, Oracle 9i, Performance/Tuning, Windows
ORA-12535: Oracle 9i
Aks2507, Something is not set properly. 1. Firewall – Check your firewalls to make sure that the port is not being blocked. 2. Verify that you are putting in the correct information IP address, Port, Service_name 3. Perform a TNSPING If the ping command succeeds, than it might be a firewall problem. Typically, when you [...]
View Answer
| June 18, 2013 2:37 PM
ORA-12535, Oracle 9i, Oracle Application Server
Aks2507, Something is not set properly. 1. Firewall – Check your firewalls to make sure that the port is not being blocked. 2. Verify that you are putting in the correct information IP address, Port, Service_name 3. Perform a TNSPING If the ping command succeeds, than it might be a firewall problem. Typically, when you [...]
View Answer
| June 18, 2013 2:37 PM
ORA-12535, Oracle 9i, Oracle Application Server
Record Locking using a COBOL program
(1) If doing a Cobol READ, you can avoid the question of locks by using READ WITH NO LOCK. (2) If doing an SQL SELECT, you can avoid the question of locks by using WITH NC as the last clause. (3) In various OSes, you can set your general commitment level to read without locking, [...]
View Answer
| June 18, 2013 10:58 PM
Application development, AS/400, COBOL, Development
(1) If doing a Cobol READ, you can avoid the question of locks by using READ WITH NO LOCK. (2) If doing an SQL SELECT, you can avoid the question of locks by using WITH NC as the last clause. (3) In various OSes, you can set your general commitment level to read without locking, [...]
View Answer
| June 18, 2013 10:58 PM
Application development, AS/400, COBOL, Development
Record Locking in RPGLE
First off, The way I read your question tells me you want to Clear a File and after that check to see who is using it. Is that correct? If so, could you explain why. I would think you would do it in the reverse order. Make sure no one is using before the clear. [...]
View Answer
| June 18, 2013 8:18 PM
AS/400, RPG Record Locks, RPGLE
First off, The way I read your question tells me you want to Clear a File and after that check to see who is using it. Is that correct? If so, could you explain why. I would think you would do it in the reverse order. Make sure no one is using before the clear. [...]
View Answer
| June 18, 2013 8:18 PM
AS/400, RPG Record Locks, RPGLE
WSUS: Connection issue
machines did not report to the WSUS server. Maybe there is a connectivity issue, that the end machine cannot contact the WSUS server. Run a client Diagnostic tool from Microsoft from the machine side. http://technet.microsoft.com/en-us/wsus/bb466192.aspx there are other tools to help you troubleshoot +++++++++++++++++++++++++++++ Two things you can do. 1) go to the client machine [...]
View Answer
| June 18, 2013 1:55 PM
IE7, IE7 mode, Internet Explorer, Window Server 2003, Windows Server Update Services, WSUS
machines did not report to the WSUS server. Maybe there is a connectivity issue, that the end machine cannot contact the WSUS server. Run a client Diagnostic tool from Microsoft from the machine side. http://technet.microsoft.com/en-us/wsus/bb466192.aspx there are other tools to help you troubleshoot +++++++++++++++++++++++++++++ Two things you can do. 1) go to the client machine [...]
View Answer
| June 18, 2013 1:55 PM
IE7, IE7 mode, Internet Explorer, Window Server 2003, Windows Server Update Services, WSUS
WSUS: Servers aren’t showing up on console
I found the answer to this. It has to do with a registry entry. If the server is created using a template, such as our vm servers, or was cloned with cloning software, then we have to go delete two registry keys. This is because the keys already exist on the original server and are [...]
View Answer
| June 18, 2013 8:33 PM
Windows Server 2008 SP2, WSUS 3.0
I found the answer to this. It has to do with a registry entry. If the server is created using a template, such as our vm servers, or was cloned with cloning software, then we have to go delete two registry keys. This is because the keys already exist on the original server and are [...]
View Answer
| June 18, 2013 8:33 PM
Windows Server 2008 SP2, WSUS 3.0
Dreamweaver Image Swap Not working in IE 6
Try replacing the ‘_’ with ‘x’ in the element names and the places where those names are used, which is only in the corresponding calls to MM_swapImage, <pre>I.E.onmouseover=”MM_swapImage(’4x6activites</pre> name=’4x6activites’>You don’t need to change any file names.
View Answer
| June 18, 2013 9:44 PM
Web site design & management
Try replacing the ‘_’ with ‘x’ in the element names and the places where those names are used, which is only in the corresponding calls to MM_swapImage, <pre>I.E.onmouseover=”MM_swapImage(’4x6activites</pre> name=’4x6activites’>You don’t need to change any file names.
View Answer
| June 18, 2013 9:44 PM
Web site design & management
Find # days between 2 dates in a AS/400 query
Hi, You should be able to do this using the DAYS function :- DAYS(Enddate) – DAYS(Startdate) Regards, Martin Gilbert.
View Answer
| June 18, 2013 3:53 PM
AS/400 Query
Hi, You should be able to do this using the DAYS function :- DAYS(Enddate) – DAYS(Startdate) Regards, Martin Gilbert.
View Answer
| June 18, 2013 3:53 PM
AS/400 Query
Find # days between 2 dates in Query 400
This Answer may help. ================================================== Unfortunately, that referenced answer doesn’t address the question. No, the startdate and enddate fields should be DATE or TIMESTAMP fields or be DATE expressions. You may convert various character fields into “dates” with a variety of functions. Overall, you shouldn’t be using Query/400 at all. Use Query Manager instead. See [...]
View Answer
| June 18, 2013 7:11 AM
AS/400 Query, iSeries development
This Answer may help. ================================================== Unfortunately, that referenced answer doesn’t address the question. No, the startdate and enddate fields should be DATE or TIMESTAMP fields or be DATE expressions. You may convert various character fields into “dates” with a variety of functions. Overall, you shouldn’t be using Query/400 at all. Use Query Manager instead. See [...]
View Answer
| June 18, 2013 7:11 AM
AS/400 Query, iSeries development
Export data from SAP to all Excel Format
Use the option List, Export, Spreadsheet and finalty use the XML format
View Answer
| June 18, 2013 12:06 PM
Export Data from SAP to Excel, SAP, SAP Export to Excel
Use the option List, Export, Spreadsheet and finalty use the XML format
View Answer
| June 18, 2013 12:06 PM
Export Data from SAP to Excel, SAP, SAP Export to Excel
I need Partition Magic for windows 2003
There are many partition resizing tools, but there is no free for Servers. It is easy to resize partitions. You just need to shrink your partition D and then extend the C drive. http://support.microsoft.com/kb/323442
View Answer
| June 17, 2013 2:23 PM
Partition Magic, Partitions, Windows Server 2003
There are many partition resizing tools, but there is no free for Servers. It is easy to resize partitions. You just need to shrink your partition D and then extend the C drive. http://support.microsoft.com/kb/323442
View Answer
| June 17, 2013 2:23 PM
Partition Magic, Partitions, Windows Server 2003
What is ATG Dynamo?
ATG Dynamo is the name of a J2EE application server offered by ATG and a web application framework for building web applications. The application framework can also be run on all major J2EE application servers (JBoss, WebLogic, WebSphere etc…). The framework forms the foundation of all ATG product such as its flagship eCommerce product which [...]
View Answer
| June 16, 2013 4:53 PM
ATG Commerce, ATG Dynamo
ATG Dynamo is the name of a J2EE application server offered by ATG and a web application framework for building web applications. The application framework can also be run on all major J2EE application servers (JBoss, WebLogic, WebSphere etc…). The framework forms the foundation of all ATG product such as its flagship eCommerce product which [...]
View Answer
| June 16, 2013 4:53 PM
ATG Commerce, ATG Dynamo
