Get answers.  Share knowledge.  Collaborate with peers.




Tools for AS/400

People create a tool to satisfy a need.
There are hundreds of free tools available on the web today.
Can you be more specific on what you are trying to accomplish?
Are you tryting to build something to sell? Or just a timesaver to give away?
What are your needs?



View Discussion   |  April 23, 2013  8:00 PM
AS/400, AS/400 tools
discussed by:
CharlieBrowne
32,785 pts.

Message subfile

Tom – I bet you didn’t think your extra tidbit of advice would be so useful so quickly. Thanks again … now that I consistantly populate the message subfile I saw that it was not properly clearing. Focussing on the api parms, I tried many combinations. Nothing worked until I reread your “Binary” advice – so I switched that parm (silly me – taking the IBM site info literally) to a 10 digit integer and it finally seems to work perfectly. So you answered my next question before I even asked it.
Have you ever thought of starting a “you want it yesterday – OK” service ? (like next day delivery only better)



View Discussion   |  April 23, 2013  7:44 PM
AS/400, MSGF, QMHSNDPM
discussed by:
aceofdelts
1,565 pts.

How to include mulitple emails as a Lotus Notes email attachment

The last poster said you could copy the text into doc and save with .eml extension. Easier to just save the email (from within notes). It automatically is saved with a .eml extension. Then just embed as a doc but will open up as an email once clicked.



View Discussion   |  April 23, 2013  6:58 PM
Lotus Notes, Lotus Notes email, Lotus Notes email attachments
discussed by:
stuarty
10 pts.

How to use SETLL and READE to solve this program

Great .. SETGT and,READPE aren’t operations that I need to use frequently.



View Discussion   |  April 23, 2013  6:49 PM
AS/400, Physical File
discussed by:
philpl1jb
44,060 pts.

How to insert Hex values through SQL/400

If you are creating a table, you have predefined fields. So I do not understand how you would insert something after the last field in the file.
If you want to insert a new record with a hex value, you can do that with SQL.

INSERT INTO yourlib/yourfile VALUES(X'3F')



View Discussion   |  April 23, 2013  3:22 PM
SQL Database, SQL Query, SQL/400
discussed by:
CharlieBrowne
32,785 pts.

discussed by:
tlsanders1
1,240 pts.

WRKQRY query

http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/c4152104.pdf
pages 111-114
To see the collating sequence
- select collating sequence
- Enter Collating sequence option 3 .. (Define the Sequende)
F15 will show the language sequence (for your computer this is English )
F14 will show hexadecimal sequence

The sequence used will determine sort order and greater then / less then logic
F23 will allow you to save a sequence as the default.

Option 3 allows you to modify the sequence .. it has upper case = lower case
a=70 and A=70. So A and a will be sorted as equal.



View Discussion   |  April 23, 2013  1:17 PM
AS/400, iSeries, WRKQRY
discussed by:
philpl1jb
44,060 pts.

Holding and restarting the job scheduler

How is the job scheduled now? — Tom



View Discussion   |  April 23, 2013  1:00 PM
Advanced Job Scheduler, AS/400 job scheduler
discussed by:
TomLiotta
107,695 pts.

How to use SETLL and READE to solve this program

Post your working code here, and we’ll see if we can help improve it. I’ll post mine after yours.

Tom



View Discussion   |  April 23, 2013  12:58 PM
AS/400, Physical File
discussed by:
TomLiotta
107,695 pts.

How to use SETLL and READE to solve this program

hey phil thanks

ur help worked, finally i did it.

bcoz of ur code i also learnt the use of SETGT ,READPE.
now feeling comfortable with these commands.



View Discussion   |  April 23, 2013  11:45 AM
AS/400, Physical File
discussed by:
rpglecodingusingas400
115 pts.

Holding and restarting the job scheduler

HI There,

There is a maintanace work scheduled and i need to put a job on hold. Can some one advice how i can put a single job on hold?

Thanks in advance.



View Discussion   |  April 23, 2013  11:32 AM
Advanced Job Scheduler, AS/400 job scheduler
discussed by:
Sagarika
30 pts.

Holding and restarting the job scheduler

How to reschedule a single job on AS400?



View Discussion   |  April 23, 2013  11:29 AM
Advanced Job Scheduler, AS/400 job scheduler
discussed by:
sagarika
30 pts.

Exchange – extracting email properties

Follow the given steps to export email addresses from Outlook 2010 emails:
1.Move or copy all the emails(from which you want to extract email addresses) into a folder.
2.Go to the Outlook File tab then, click Options.
3.Choose “Advanced” from the Options dialog box .
4.Click “Export” from the Export section on the right.
5.Then, select “Export to a file” and click Next.
6.Choose “Comma Separated Values(Windows)” and click Next.
7.Select the folder containing your emails and click Next.
8.Choose a location to save the spreadsheet and click Next.
9.Click the “Map custom fields” button.
10.Choose the desired fields to be exported.
11.Click finish.



View Discussion   |  April 23, 2013  10:06 AM
Microsoft Exchange 2007, SQL Server tables
discussed by:
stellariinformation
245 pts.

Error code

Which operating system are you using ?
This error occurs due to windows registry problems. Whenever, the .DLL files in the windows registry gets corrupt then, this error can occur.You can solve the problem by using a registry cleaner to scan and fix the registry issues of your system .



View Discussion   |  April 23, 2013  9:44 AM
Windows 7, Windows 7 error messages
discussed by:
stellariinformation
245 pts.

How to solve an Outlook archiving problem

The default maximum PST file size for Outlook 2007 is 20 GB. The error message is showing that your PST file has reached the maximum storage limit. You can create a new PST file for storing
further data.
You can also configure the maximum PST file size by editing the MaxFileSize registry entry.
For more Info visit:http://support.microsoft.com/kb/832925



View Discussion   |  April 23, 2013  9:43 AM
Microsoft Outlook 2007, Microsoft Outlook error messages
discussed by:
stellariinformation
245 pts.

How do I switch back to Yahoo mail classic?

1.Start Firefox
2.Go to Tools>Options
3.Open Content tab then un select the checkbox “Enable JavaScript”.
4.Now, login your Yahoo mail .
5.You will get a message prompted on your screen that “JavaScript is needed to be enabled for using the new Yahoo! Mail.”
There will be two options:
->First option to switch to a previous version of Yahoo! Mail just for one time
->second option to return to a previous version.
6.You can choose the desired one, it will bring you back to the classic Yahoo! Mail version.



View Discussion   |  April 23, 2013  9:42 AM
Yahoo, Yahoo Mail
discussed by:
stellariinformation
245 pts.

Does a 240 HZ make a difference vs 120 HZ?

Try making video of your screen through mobile and you will see the difference.



View Discussion   |  April 23, 2013  8:52 AM
Cisco, Linc, Video conferencing
discussed by:
Jack521
10 pts.

Windows SBS 2008 Backup

I found an answer to the problem here.  It turns out you have to change the size limit for shadow copies.  I lowered mine as in the article to 300 and the backup started immediately.



View Discussion   |  April 23, 2013  6:21 AM
Backup and recovery management software, SBS 2008, Small Business Server 2008, Windows Server backup, Windows Small Business Server
discussed by:
techdude123
10 pts.

Does a 240 HZ make a difference vs 120 HZ?

I’d be surprised if it made any significant difference for video-conferencing. Maybe for football or basketball. But you probably should be asking that kind of question in a TV electronics discussion forum. — Tom



View Discussion   |  April 23, 2013  5:57 AM
Cisco, Linc, Video conferencing
discussed by:
TomLiotta
107,695 pts.

SFLLIN

I was hoping that I was having a senior moment (like usual).

Of course, no one uses the arrow down key or the mouse.
It’s tab or enter and ‘X’ to select. Page Down to get to the next page.

Great .. alternating record sequence.

Load the array .. then load the page(s) from the array..great plan.

That will be fun.

It’s a small set .. just a few pages.

Thanks..Tom



View Discussion   |  April 23, 2013  2:32 AM
AS/400, DSPF, SFLLIN
discussed by:
philpl1jb
44,060 pts.