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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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