Get answers.  Share knowledge.  Collaborate with peers.




Transfer AS/400 to Excel

You can create a single CL program that to do the transfers. IT is still one file at a time, Or that one CL program could submit multiple batch jobs.
What process are you using today to do the transfers?



View Discussion   |  April 18, 2013  12:24 PM
AS/400, Microsoft Excel 2010
discussed by:
CharlieBrowne
32,865 pts.

RSYNC hangs without reason

The CPU drops down to 2% normally a 15% during the operation. I watch the last modify date and it was 5 days before i start the back-up. I don’t know the problem but I had restart the operation and after checking for change files rsync reach that one file where it hangs but this time it just back-up it without any problem and the back-up operation. Maybe the reason was the virtual machine. It could be that this machines network interface had some problems when it runs on maximum for hours



View Discussion   |  April 18, 2013  12:23 PM
Debian, Linux
discussed by:
jackieserver
180 pts.

Key list in AS/400

Option 1. Create an LF with the keys that you want
Option 2. Use Opnqryf
Option 3. Use embedded SQL



View Discussion   |  April 18, 2013  12:06 PM
AS/400, AS/400 logical file
discussed by:
RamvishakRamesh
1,955 pts.

2 Dimensional Array in RPGLE

Hi Tom,

If we make 2 d arrays using qualified ds, then we can’t search any element using %lookup.
So, how to make a 2d array so that %lookup works??



View Discussion   |  April 18, 2013  12:03 PM
iSeries RPGLE, RPGLE array
discussed by:
sirevil
10 pts.

Execution of formula language in a LotusScript agent without using evaluate statement

Situation is like this I have keyword document, in which there is text field and in that we are providing an @if condition example:

@If( condition1 ; action1 ; condition2 ; action2 ; ; condition99 ; action99 ; else_action )  like this i have a very big if condition, and we are using evaluate statement to execute this @if formula condition, but we are getting an error.



View Discussion   |  April 18, 2013  11:43 AM
LotusScript, LotusScript Agent
discussed by:
ridhi143
15 pts.

24 digit number: Arithmetic operations?

As a side note, REXX has handled numbers of essentially any scale (up to the general 16MB limit) from essentially the beginning. — Tom



View Discussion   |  April 18, 2013  11:42 AM
COBOL/400, IBMi, RPG
discussed by:
TomLiotta
108,135 pts.

Date conversion

Can you format the code better? I can’t quite tell what it is saying. — Tom



View Discussion   |  April 18, 2013  11:31 AM
AS/400, AS/400 Fields
discussed by:
TomLiotta
108,135 pts.

24 digit number: Arithmetic operations?

It would only be a problem if you are using an old obsolete AS/400; and if that’s the case, no one can help because you didn’t tell us critical information. Even in V5R3 (which is also so old that it’s been out of support for four years), COBOL can handle 24-digit numbers and larger.

.
Here is debug output from a COBOL program on V5R3 that shows the value of a 24-digit number:
 Debug . . .
 .
 F3=End program   F6=Add/Clear breakpoint   F10=Step
 F12=Resume       F17=Watch variable   F18=Work with
 BIG-NBR = 000000000000000000000052.
I don’t know why you’re having trouble. You need to tell us about your environment because it has worked with larger than 24 digits for a number of years.
.
Tom


View Discussion   |  April 18, 2013  11:07 AM
COBOL/400, IBMi, RPG
discussed by:
TomLiotta
108,135 pts.

How to solve an Outlook archiving problem

Yes it is true that Outlook 2007 offers PST file size limit of 20 GB. But this is the expandable limit upto which you can expand the size. However normally as soon as you reach to around 4 GB and 5 GB, Outlook starts showing such warning messages of oversize etc. and also makes it slow. As Paul, suggested you can either expand the size by making registry changes or simply can use some other alternative solutions like compact oversized PSTfile automatically or manually with Compact Now setting in Outlook. However manual step takes a lot of time so I will recommend the automatic way. You can check this blog post http://it.toolbox.com/blogs/recover-outlook/all-about-compacting-outlook-pst-file-53163 . Hope this will help you in reducing the size of Outlook.

Regards
Maria



View Discussion   |  April 18, 2013  10:52 AM
Microsoft Outlook 2007, Microsoft Outlook error messages
discussed by:
mariapete
200 pts.

Transfer Lotus Notes email to Outlook

You can convert lotus notes emails to Outlook file. Use a NSF to PST converter to accomplish this task.

Regards
Maria



View Discussion   |  April 18, 2013  10:51 AM
Lotus Notes 5.8, Microsoft Outlook
discussed by:
mariapete
200 pts.

How do I copy Outlook contacts

Follow these steps :
-Open Outlook and click on Contacts in bottom left corner of Outlook Window.
-Now click on File -> Import and Export and select the ‘Export a File’.
-Click Next. Select Personal Folder File and click Next twice. But make sure that Contact folder is selected.
-Click Browse to save the contact data at any desired location and then click finish.
-You can copy this file into any portable device like pen drive, CD etc. and then later import it into Outlook of your laptop.

Regards
Maria



View Discussion   |  April 18, 2013  10:50 AM
Microsoft Outlook, Microsoft Outlook contacts
discussed by:
mariapete
200 pts.

Microsoft Outlook error

To fix this issue you can use any of these two methods:
-Reset your Internet browser settings
-Export/Import the registry key from another computer

You can follow the complete steps from this Microsoft KB – http://support.microsoft.com/kb/310049

Regards
maria



View Discussion   |  April 18, 2013  10:48 AM
Microsoft Outlook, Microsoft Outlook error messages
discussed by:
mariapete
200 pts.

Emails not entering inbox

You can do following things :
Check your Outlook for any Rule or Filter.
Check Junk Mail Folder
Check your Anti-virus software
Search for messages which you have received today
If nothing helps then contact your ISP administrator

Regards
Maria



View Discussion   |  April 18, 2013  10:47 AM
Microsoft Outlook, Microsoft Outlook issues
discussed by:
mariapete
200 pts.

24 digit number: Arithmetic operations?

One problem is the length of the number. 24 digit integer is out of limitations of Cobol, Java etc.
The solution is to cut the number into pieces: 9 digits, 7 digits, 7 digits 1 digit. Calculate the modulo of part one, concatenate it with part 2, modulo again and so on. The algorithm is well known. The calculation itself is about simple 10 lines ob Cobol code.

I just wrote a simple Cobol program for AS/400 doing this:
CALL PGM(IBANLIB/IBANCALC) PARM(’54092400′ ’123456′ ”)
parm 1 = bank code, parm 2 = account, parm 3 = outparm IBAN.

In addition to the modulo calculation you need some simple code for the specialties of some banks. The final documentation is available from Bundesbank since April 03.

Also I would add the usual SQL lines, so that Cobol programs can be called from programs/CLs inside the AS/400, as well as from outside as a service, like from Java programs like this:
ProgramCall instanceProgramCall = new ProgramCall(instanceAS400Session, “/QSYS.LIB/IBANLIB.LIB/IBANCALC.PGM”, as400parm);

Maybe I will publish the code on some freeware download platform, or sell it for a sixpack beer.



View Discussion   |  April 18, 2013  10:16 AM
COBOL/400, IBMi, RPG
discussed by:
gast951
75 pts.

Date conversion

Great, now I need to compare the dates. I have a wDateA field of 6A which contains date data stored as ddmmyy and wDate1 which is of 8A contains date data as yyyymmdd and wDate2 which is also of 8A and contains date data as yyyymmdd. Now I want to know whether the 6A date field(wDateA ) is between wDate1 and wDate2
I tried like this but it is crashing with ‘receiver too small’ error.
%Date(wDateA:*DMY0) %Date(wDate2:*Ymd)



View Discussion   |  April 18, 2013  8:55 AM
AS/400, AS/400 Fields
discussed by:
RamvishakRamesh
1,955 pts.

Call detail recording and DID

This looks very much like an academic question. Why is it assumed that there are “2 steps”? — Tom



View Discussion   |  April 18, 2013  8:07 AM
CDR, PBX
discussed by:
TomLiotta
108,135 pts.

Date conversion

Simplest might be [ eval wDAte = %date(wISODate) ]. — Tom



View Discussion   |  April 18, 2013  8:05 AM
AS/400, AS/400 Fields
discussed by:
TomLiotta
108,135 pts.

Position at which value is entered in a subfile

The subfile relative record number value can be specifically retrieved from the I/O feedback area for ICF and display files without any “keyword”. — Tom



View Discussion   |  April 18, 2013  7:57 AM
AS/400, AS/400 Subfiles
discussed by:
TomLiotta
108,135 pts.

Position at which value is entered in a subfile

The “keyword” would be SFILE(recformat:rrnfield). — Tom



View Discussion   |  April 18, 2013  7:52 AM
AS/400, AS/400 Subfiles
discussed by:
TomLiotta
108,135 pts.

Position at which value is entered in a subfile

hi Philip,
Readc Will read the changes made and fetch the value which is entered, not the position in which it is entered.



View Discussion   |  April 18, 2013  5:47 AM
AS/400, AS/400 Subfiles
discussed by:
jainamit
380 pts.