AS/400 – Chain file
Take a look at Chain(n). N modifier doesn’t lock the record. Another way is to use SETLL and READ in a loop and when you found your record proceed to use the CHAIN method for update. Regards.
View Answer
| June 19, 2013 2:55 PM
AS/400 Records, AS400- File, Record lock, RPG Record Locks
Take a look at Chain(n). N modifier doesn’t lock the record. Another way is to use SETLL and READ in a loop and when you found your record proceed to use the CHAIN method for update. Regards.
View Answer
| June 19, 2013 2:55 PM
AS/400 Records, AS400- File, Record lock, RPG Record Locks
ISA Server 2004 server
How’s your network laid out, where are the two devices in relation to each other and any other routing/forwarding devices? Your clients should be sending their data to the router directly for access to resources on the 172.30 network as their gateway, not the ISA Server, assuming you mean non internet-based resources like user data, [...]
View Answer
| June 19, 2013 6:40 AM
Microsoft Windows
How’s your network laid out, where are the two devices in relation to each other and any other routing/forwarding devices? Your clients should be sending their data to the router directly for access to resources on the 172.30 network as their gateway, not the ISA Server, assuming you mean non internet-based resources like user data, [...]
View Answer
| June 19, 2013 6:40 AM
Microsoft Windows
ISA Server 2004 user bandwidth
ISAserver.org website lists few add-in sofware to ISA that control the bandwidth.
View Answer
| June 19, 2013 5:06 PM
Bandwidth limits, Bandwidth management, ISA Server 2004, User restrictions
ISAserver.org website lists few add-in sofware to ISA that control the bandwidth.
View Answer
| June 19, 2013 5:06 PM
Bandwidth limits, Bandwidth management, ISA Server 2004, User restrictions
AS400 and CLLE: PGM issue
hi …. Use following reference.. PGM DCL VAR(&WS) TYPE(*CHAR) LEN(10) /* variable */ DCL VAR(&WSPID4) TYPE(*CHAR) LEN(10) /*DSPF field*/ DCLF FILE(KRGUNN/TP001P) OPNID(OP1) /*PF*/ DCLF FILE(KRGUNN/TPW005D) RCDFMT(RECDSP) OPNID(OP2) /*DSPF*/ LOOP: SNDRCVF RCDFMT(RECDSP) OPNID(OP2) RCVF RCDFMT(RECF OF PF) OPNID(OP1) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) /* TO CHECK END OF FILE */ CHGVAR VAR(&WS) VALUE(&OP1_PDPID) /* SYNTAX OF MOVEING [...]
View Answer
| June 19, 2013 8:45 AM
as/400 data, CLLE, PGM
hi …. Use following reference.. PGM DCL VAR(&WS) TYPE(*CHAR) LEN(10) /* variable */ DCL VAR(&WSPID4) TYPE(*CHAR) LEN(10) /*DSPF field*/ DCLF FILE(KRGUNN/TP001P) OPNID(OP1) /*PF*/ DCLF FILE(KRGUNN/TPW005D) RCDFMT(RECDSP) OPNID(OP2) /*DSPF*/ LOOP: SNDRCVF RCDFMT(RECDSP) OPNID(OP2) RCVF RCDFMT(RECF OF PF) OPNID(OP1) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) /* TO CHECK END OF FILE */ CHGVAR VAR(&WS) VALUE(&OP1_PDPID) /* SYNTAX OF MOVEING [...]
View Answer
| June 19, 2013 8:45 AM
as/400 data, CLLE, PGM
AS/400 and CLLE subfile
You can use a UIM Panel to display records, which gives a similar effect I found this ancient example.
View Answer
| June 19, 2013 2:52 PM
AS400 iseries, CLLE
You can use a UIM Panel to display records, which gives a similar effect I found this ancient example.
View Answer
| June 19, 2013 2:52 PM
AS400 iseries, CLLE
Experience with Change Management Software
We use Aldon/CMS (iSeries only solution). We have had very good experience with it. Intuitive interface for the most part. The Winders side of the shop still uses Source Safe <shudder>, so we have no experience with any REAL tools on that side of the aisle.
View Answer
| June 19, 2013 4:56 PM
Development, Lifecycle development, Project management, Sarbanes-Oxley Act, Software Quality Assurance
We use Aldon/CMS (iSeries only solution). We have had very good experience with it. Intuitive interface for the most part. The Winders side of the shop still uses Source Safe <shudder>, so we have no experience with any REAL tools on that side of the aisle.
View Answer
| June 19, 2013 4:56 PM
Development, Lifecycle development, Project management, Sarbanes-Oxley Act, Software Quality Assurance
Change Management Software to be PCI compliant
I’ve been in Turnover and Aldon shops. The price is fairly comparable. I’m curious with only four developers what is your PCI level? If you are a level 3 or 4 you might be able to talk your PCI auditor into letting you get away with a homegrown change control system as long as it [...]
View Answer
| June 19, 2013 8:13 PM
AS/400, Change management
I’ve been in Turnover and Aldon shops. The price is fairly comparable. I’m curious with only four developers what is your PCI level? If you are a level 3 or 4 you might be able to talk your PCI auditor into letting you get away with a homegrown change control system as long as it [...]
View Answer
| June 19, 2013 8:13 PM
AS/400, Change management
SQL Server 2005 information
Well first you might want to start with one of the two newer versions of Microsoft SQL Server. You can look at the SQL Server certification exams. They will however require a lot of studying and experience, as will getting any job in the field.
View Answer
| June 19, 2013 6:41 AM
SQL, SQL Server, SQL Server 2005, SQL Server career advice, SQL Server certifications
Well first you might want to start with one of the two newer versions of Microsoft SQL Server. You can look at the SQL Server certification exams. They will however require a lot of studying and experience, as will getting any job in the field.
View Answer
| June 19, 2013 6:41 AM
SQL, SQL Server, SQL Server 2005, SQL Server career advice, SQL Server certifications
Problem with Hyper-V snapshots – unable to start VM
Perhaps the VHD image file you are trying to use is set to read only. To fix this right-click the file > properties, and un-tick the Read-only box.
View Answer
| June 19, 2013 7:22 PM
Hyper-V, Windows 2008 R2
Perhaps the VHD image file you are trying to use is set to read only. To fix this right-click the file > properties, and un-tick the Read-only box.
View Answer
| June 19, 2013 7:22 PM
Hyper-V, Windows 2008 R2
SQL Server 2005: SQL statement in a variable
This is the quick and dirty: DECLARE @SQL VARCHAR(8000) , @SQLVariable INT SET @SQLVariable = 1 SET @SQL = ‘SELECT * FROM Table WHERE Value = ‘ + CAST( @SQLVariable AS VARCHAR( 5 ) ) EXEC( @SQL ) For a more secure solution research sp_executesql in BOL.
View Answer
| June 19, 2013 5:34 PM
SQL, SQL Server 2005, SQL statements, SQL variables
This is the quick and dirty: DECLARE @SQL VARCHAR(8000) , @SQLVariable INT SET @SQLVariable = 1 SET @SQL = ‘SELECT * FROM Table WHERE Value = ‘ + CAST( @SQLVariable AS VARCHAR( 5 ) ) EXEC( @SQL ) For a more secure solution research sp_executesql in BOL.
View Answer
| June 19, 2013 5:34 PM
SQL, SQL Server 2005, SQL statements, SQL variables
SQL vs RPG: Which is faster?
Sometimes SQL can be faster and sometimes not. RPG uses the views of the file (logical view or physical if file is keyed). If the view is helpful in getting what you want or need is a relatively small number of steps, it will appear to be fast. If you have a view that does [...]
View Answer
| June 19, 2013 7:20 PM
RPG, SQL
Sometimes SQL can be faster and sometimes not. RPG uses the views of the file (logical view or physical if file is keyed). If the view is helpful in getting what you want or need is a relatively small number of steps, it will appear to be fast. If you have a view that does [...]
View Answer
| June 19, 2013 7:20 PM
RPG, SQL
Using External Datastructure in RPG
an externally defined data structure is used to allow a pre-defined (normally field level definition) to be used to map the data in a data structure rather than defining it explicitly in the program therefore if you want a data structure where the information is in the same format as one of your files then [...]
View Answer
| June 19, 2013 3:02 PM
AS/400, RPG
an externally defined data structure is used to allow a pre-defined (normally field level definition) to be used to map the data in a data structure rather than defining it explicitly in the program therefore if you want a data structure where the information is in the same format as one of your files then [...]
View Answer
| June 19, 2013 3:02 PM
AS/400, RPG
AS/400 command for full system backup
I’ve listed the commands required to complete an opt 21, 22 and 23. Opt 21 will get you everything on the system but it must be ran while the system is in a restricted status. For more info: <a href=”http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzaiu/rzaiurzaiu2tv.htm”>click</a> For option 21 (Entire system) these prompt displays appear: ENDSBS SBS(*ALL) OPTION(*IMMED) SAVSYS SAVLIB LIB(*NONSYS) [...]
View Answer
| June 19, 2013 3:59 PM
AS/400, AS/400 backup
I’ve listed the commands required to complete an opt 21, 22 and 23. Opt 21 will get you everything on the system but it must be ran while the system is in a restricted status. For more info: <a href=”http://publib.boulder.ibm.com/iseries/v5r2/ic2924/index.htm?info/rzaiu/rzaiurzaiu2tv.htm”>click</a> For option 21 (Entire system) these prompt displays appear: ENDSBS SBS(*ALL) OPTION(*IMMED) SAVSYS SAVLIB LIB(*NONSYS) [...]
View Answer
| June 19, 2013 3:59 PM
AS/400, AS/400 backup
AS/400 administration course from IBM
If you are really good in as400 administration, you can really go far. not only that, with the knowledge, you are able to troubleshoot a lot of stuff without help of IBM (depends on how deep the problem is). there are a lot of things to learn from as400 administration.
View Answer
| June 19, 2013 8:05 AM
AS400 admin
If you are really good in as400 administration, you can really go far. not only that, with the knowledge, you are able to troubleshoot a lot of stuff without help of IBM (depends on how deep the problem is). there are a lot of things to learn from as400 administration.
View Answer
| June 19, 2013 8:05 AM
AS400 admin
Decimal data error in RPG
If this is really how you define it in RPG: <pre> D btime 4 0 </pre> Then this is incorrect in CL: <pre> var(&tim) type(*dec) len(4,0) </pre> One or the other is wrong. The two types are not the same — it’s zoned-decimal in RPG and packed-decimal in CL. The RPG is zoned-decimal because you [...]
View Answer
| June 19, 2013 1:45 AM
Decimal Data Error, RPG, RPGLE
If this is really how you define it in RPG: <pre> D btime 4 0 </pre> Then this is incorrect in CL: <pre> var(&tim) type(*dec) len(4,0) </pre> One or the other is wrong. The two types are not the same — it’s zoned-decimal in RPG and packed-decimal in CL. The RPG is zoned-decimal because you [...]
View Answer
| June 19, 2013 1:45 AM
Decimal Data Error, RPG, RPGLE
Trap decimal data error in COBOL/400
you could set the data type on the field to D this means only digts 0-9 can be entered Michael Dratwa wrote: Have the numeric field redefined as alphanumeric (or move the field to a test alphanumeric fld) and use the test for numeric’s. 01 ws-data-record. 05 ws-data-fld1 pic 9(5). 05 ws-data-fld1x redefines ws-data-fld1 pic [...]
View Answer
| June 19, 2013 3:32 PM
CL, COBOL/400, Decimal Data Error
you could set the data type on the field to D this means only digts 0-9 can be entered Michael Dratwa wrote: Have the numeric field redefined as alphanumeric (or move the field to a test alphanumeric fld) and use the test for numeric’s. 01 ws-data-record. 05 ws-data-fld1 pic 9(5). 05 ws-data-fld1x redefines ws-data-fld1 pic [...]
View Answer
| June 19, 2013 3:32 PM
CL, COBOL/400, Decimal Data Error
Difference between Oracle editions
Oracle Database Standard Edition One is designed for deployment in small businesses, line-of-business departments, and distributed branch environments. It is available on single server systems supporting up to a maximum of 2 CPUs and is easy to install, configure, complete with built in self-management capabilities. Oracle Database Standard Edition One manages all your data, and [...]
View Answer
| June 19, 2013 5:45 AM
Automated, Development, Software Quality Assurance
Oracle Database Standard Edition One is designed for deployment in small businesses, line-of-business departments, and distributed branch environments. It is available on single server systems supporting up to a maximum of 2 CPUs and is easy to install, configure, complete with built in self-management capabilities. Oracle Database Standard Edition One manages all your data, and [...]
View Answer
| June 19, 2013 5:45 AM
Automated, Development, Software Quality Assurance
Difference between different SAP platforms
MRP An MRP system is intended to simultaneously meet three objectives: Ensure materials and products are available for production and delivery to customers. Maintain the lowest possible level of inventory. Plan manufacturing activities, delivery schedules and purchasing activities Manufacturing organizations, whatever their products, face the same daily practical problem – that customers want products to [...]
View Answer
| June 19, 2013 4:31 PM
ABAP, Basis, CO, ED, FI, Financials, MySAP, SAP, SAP careers, TR
MRP An MRP system is intended to simultaneously meet three objectives: Ensure materials and products are available for production and delivery to customers. Maintain the lowest possible level of inventory. Plan manufacturing activities, delivery schedules and purchasing activities Manufacturing organizations, whatever their products, face the same daily practical problem – that customers want products to [...]
View Answer
| June 19, 2013 4:31 PM
ABAP, Basis, CO, ED, FI, Financials, MySAP, SAP, SAP careers, TR
Primary file
Essentially, the RPG Cycle does a do while not end of file loop and reads in the file one record at a time. You only code the logic within the loop (that is the processing that is to be done for each record) It is possible to specify some initialization, finalization (LR) and “level break” [...]
View Answer
| June 19, 2013 1:54 PM
AS/400, RPG Logic Cycle
Essentially, the RPG Cycle does a do while not end of file loop and reads in the file one record at a time. You only code the logic within the loop (that is the processing that is to be done for each record) It is possible to specify some initialization, finalization (LR) and “level break” [...]
View Answer
| June 19, 2013 1:54 PM
AS/400, RPG Logic Cycle
How can I find all the mac address on a LAN?
Finding all available MAC addresses on your network can be a tedious task, especially if your clients are running firewall software that blocks requested initiated from other hosts. Despite that, a quick and easy search on Google.com, e.g ‘LAN MAC address scanner’ will reveal a number of software products that you can use to achieve [...]
View Answer
| June 19, 2013 4:34 AM
LAN, MAC address, VB.NET
Finding all available MAC addresses on your network can be a tedious task, especially if your clients are running firewall software that blocks requested initiated from other hosts. Despite that, a quick and easy search on Google.com, e.g ‘LAN MAC address scanner’ will reveal a number of software products that you can use to achieve [...]
View Answer
| June 19, 2013 4:34 AM
LAN, MAC address, VB.NET
