Get answers.  Share knowledge.  Collaborate with peers.




How to read from flat file

Thanks a ton. that field did it.. Really thanks for all the help.



View Discussion   |  April 9, 2013  5:32 AM
AS/400, as/400 files
discussed by:
Prashanth123
135 pts.

How the Lansa program objects with older version can be migrated to higher vesrsion

it’s V5R4M0.,Yes they do run successfully in current system.



View Discussion   |  April 9, 2013  4:41 AM
AS/400, LANSA
discussed by:
6r
940 pts.

Protect and Overlay

Overlay is used when a display record is to remain on the screen when another record is written to the screen. It will keep the original record on the screen if there is no overlap .. one record writes to the top xx rows and the other record does not write to any of those rows.



View Discussion   |  April 9, 2013  2:47 AM
AS400. RPG
discussed by:
philpl1jb
44,220 pts.

UPK 3.5.1 error

UPK 3.5.1 is so old that I can’t find any documentation for it. You probably should use a more current release. Current UPK version is 11.1, but it might be possible to download and use UPK 3.6.1. What platform are you trying to install against? — Tom



View Discussion   |  April 9, 2013  2:04 AM
UPK, UPK 3.5.1
discussed by:
TomLiotta
108,360 pts.

discussion editor has no features

Logging in is what removes everything that disappears for me. That’s why Google Chrome has been useful. When I jump to a new ‘incognito’ session, it’s all fresh. I can format the comment, then submit it by following the login steps under the ‘Discuss’ area. Once that comment submits, I close that session and continue in the original session. It’s a bit less of a problem. One oddity is that it only leaves a blank line between the first two paragraphs. Subsequent paragraphs have no blank line between them. A second difference is that blocks don’t start on new lines. — Tom



View Discussion   |  April 9, 2013  1:30 AM
it Knowledge exchange formatting
discussed by:
TomLiotta
108,360 pts.

How the Lansa program objects with older version can be migrated to higher vesrsion

What OS version are you converting from or upgrading from? Do the objects run successfully on your current system? Any documents on LANSA have to come from the LANSA company. Try http://www.lansa.com/ . — Tom



View Discussion   |  April 9, 2013  1:08 AM
AS/400, LANSA
discussed by:
TomLiotta
108,360 pts.

Spool file info

Since it’s a program rather than a procedure, calling QSPRILSP is just like calling any *PGM. The four parms are defined in the documentation. A trivial example might look like this:pgm ( +

       )
/* */
   dcl   &rtnvar      *char    70
   dcl   &lrtnvar     *int            value( 70 )
/* */
   dspfd       QSYSPRT output( *PRINT ) fileatr( *PRTF )
   call        QSPRILSP  ( +
                           &rtnvar      +
                           &lrtnvar     +
                           'SPRL0100'   +
                           x'0000000000000000' +
                         )
/* */
   dmpclpgm
/* */
   return
/* */
endpgm
Compare that to the documentation. Run it, and also compare its output to the documentation.
If there are questions, post back here.
Tom


View Discussion   |  April 9, 2013  1:02 AM
iSeries, Spool file
discussed by:
TomLiotta
108,360 pts.

Different queues

The differences are that the first two are queues, the third are files that are spooled and the fourth are definitions of files that will be printed. The first is a queue for messages and the second is a queue for spooled files. Examples can be found on essentially any AS/400. You can find examples by looking on your system. The QSYSOPR *MSGQ is a message queue. The PRT01 *OUTQ is an output queue. Any entry on the PRT01 *OUTQ is a reference to a spooled file. And the QSYSPRT *FILE is a printer file. — Tom



View Discussion   |  April 9, 2013  12:33 AM
AS/400, AS/400 queue
discussed by:
TomLiotta
108,360 pts.

Protect and Overlay

The two keywords are essentially unrelated, so I don’t know any reason to use them together. I could probably make up a reason if I thought about it. As for what they are, definitions are in the DDS keyword entries for display files topic in the Information Center. — Tom



View Discussion   |  April 9, 2013  12:20 AM
AS400. RPG
discussed by:
TomLiotta
108,360 pts.

Control Indicators

To get information on control indicators, you need to go back to an earlier version of RPG, RPG/400. The manual is from 1994, so it’s old information that isn’t used much now.

Download the RPG/400 User’s Guide (.PDF). See Chapter 3. RPG/400 Indicators, subtopic ‘Control Level Indicators (L1-L9)’.
Detail definition and a complete example is in the manual.
Tom


View Discussion   |  April 9, 2013  12:01 AM
AS/400, RPG
discussed by:
TomLiotta
108,360 pts.

How can I restrict user to delete any document form Windows Server?

Make sure that Modify is not granted, just Read.



View Discussion   |  April 8, 2013  11:17 PM
Windows Server 2003, Windows Server Permissions
discussed by:
AndreaF
6,150 pts.

Spool file info

If you have TAATOOLS check out RTVSPLFA. It returns lots of good info.



View Discussion   |  April 8, 2013  8:20 PM
iSeries, Spool file
discussed by:
WoodEngineer
5,525 pts.

How to read MS SQL tables using iSeries RPG

Thanks for the tip, Depe. That looks good.



View Discussion   |  April 8, 2013  8:15 PM
iSeries, RPG Program, SQL 2008
discussed by:
WoodEngineer
5,525 pts.

How do I retrieve the most recent date from an access database

Make sure the date is stored in a true Date data-type field for this to work.



View Discussion   |  April 8, 2013  6:44 PM
Access 2003, Access Database, Microsoft Access
discussed by:
mlwonio
90 pts.

Blank spreadsheet

Are you sure that you just cannot see the cells and they weren’t accidentally deleted or cleared? You may have hidden your columns. Try CTL-A to select all then right click and select unhide.Are you on the correct worksheet? Check the tabs at the bottom. If still nothing shows, then check the size of your in bytes , does it seem too small?



View Discussion   |  April 8, 2013  4:26 PM
Blank screen
discussed by:
ToddN2000
3,915 pts.

Toshiba Satellite SP10-304 laptop

All that I could find on this was that it is below the optical drive. Some sites suggest removing the drive the access the HDD.

-Paul



View Discussion   |  April 8, 2013  4:09 PM
Laptops, toshiba
discussed by:
LinuxCiscoman
775 pts.

Spool file info

I have never used API’s before. The one I would need is QSPRILSP, but how do I use this in a CL?



View Discussion   |  April 8, 2013  3:25 PM
iSeries, Spool file
discussed by:
RayM
265 pts.

What is the performance parameter for cloud computing?

Cloud computing is in three forms public clouds, private clouds and hybrids clouds. cloud computing depending on the type of data you’re working with business objective.



View Discussion   |  April 8, 2013  2:21 PM
Cloud Computing, cloud computing management
discussed by:
at123456
65 pts.

discussion editor has no features

Wow, it all went bad for me when I signed in..
But perhaps we got a java update that you didn’t.
Or you got something that we didn’t.
.



View Discussion   |  April 8, 2013  2:17 PM
it Knowledge exchange formatting
discussed by:
philpl1jb
44,220 pts.

How the Lansa program objects with older version can be migrated to higher vesrsion

..Also any document to understand LANSA what it is and how it works and
any link to link to understand LANSA in detail or some informative link to understand LANSA,what we need to do for LANSA objects to run on V6 .
how to comile them etc…?



View Discussion   |  April 8, 2013  1:38 PM
AS/400, LANSA
discussed by:
6r
940 pts.