Sorting alphanumeric field with hexadecimal values
We have a task where we have to convert key numeric field (8,0) to alphanumeric field (8A) with hexadecimal values (’00000000′ – ‘FFFFFFFF’). The problem in sorting with alphanumeric is the alphabet is less than the numeric value (A-Z < 0-9). Is there a way, by LF or any AS400 utility, that can sort hexadecimal [...]
Answer Question
| March 23, 2012 4:17 PM
AS/400, CL, RPG
We have a task where we have to convert key numeric field (8,0) to alphanumeric field (8A) with hexadecimal values (’00000000′ – ‘FFFFFFFF’). The problem in sorting with alphanumeric is the alphabet is less than the numeric value (A-Z < 0-9). Is there a way, by LF or any AS400 utility, that can sort hexadecimal [...]
Answer Question
| March 23, 2012 4:17 PM
AS/400, CL, RPG
I need to secure by Client access sessions using SSL. Does anybody have the detailed steps for the same.
I need to secure by Client access sessions using SSL. Does anybody have the detailed step for the same.We are on i v6R1
Answer Question
| March 17, 2012 3:44 PM
AS/400 Client Access, iSeries V6R1
I need to secure by Client access sessions using SSL. Does anybody have the detailed step for the same.We are on i v6R1
Answer Question
| March 17, 2012 3:44 PM
AS/400 Client Access, iSeries V6R1
some old emails are going out of my server
hi my exchange dat base size is 102 gb approx and when i mount the mailbox the some old mails get sent to the client ?can you pls assist me
Answer Question
| March 17, 2012 7:10 AM
Client Access, Microsoft Exchange
hi my exchange dat base size is 102 gb approx and when i mount the mailbox the some old mails get sent to the client ?can you pls assist me
Answer Question
| March 17, 2012 7:10 AM
Client Access, Microsoft Exchange
AS/400 FTP error 23
I am trying to make a *ssl connection to another server and keep getting FTP Secure connection error, return code -23
Answer Question
| March 17, 2012 10:49 PM
AS/400, AS/400 error messages, SSL connection
I am trying to make a *ssl connection to another server and keep getting FTP Secure connection error, return code -23
Answer Question
| March 17, 2012 10:49 PM
AS/400, AS/400 error messages, SSL connection
Windows Subfile
hi , i woant to pop up my window when i press F4(help) in a particuler field my problem is this when i press F4 any where popup window displayed Thanks in Advance
Answer Question
| March 17, 2012 11:39 AM
AS/400, Windows subfile
hi , i woant to pop up my window when i press F4(help) in a particuler field my problem is this when i press F4 any where popup window displayed Thanks in Advance
Answer Question
| March 17, 2012 11:39 AM
AS/400, Windows subfile
Restoring AS/400 i520 system
what is the sequence in restoring the AS/400 i520 system after you have restored the OS
Answer Question
| March 17, 2012 3:45 PM
AS/400, AS/400 i520
what is the sequence in restoring the AS/400 i520 system after you have restored the OS
Answer Question
| March 17, 2012 3:45 PM
AS/400, AS/400 i520
QSYSPRT
Hi , A program generated two reports.There is a job that runs every monday , and these report are generated every week.They are copying the data in the report to a work file in Qtemp by the command CPYSPLF .Then they copy the records from work file to Qsysprt by CPYF. My queries are , [...]
Answer Question
| March 1, 2012 1:49 PM
CPYSPLF, Microsoft Excel, QSYSPRT
Hi , A program generated two reports.There is a job that runs every monday , and these report are generated every week.They are copying the data in the report to a work file in Qtemp by the command CPYSPLF .Then they copy the records from work file to Qsysprt by CPYF. My queries are , [...]
Answer Question
| March 1, 2012 1:49 PM
CPYSPLF, Microsoft Excel, QSYSPRT
AS400
How can i get the count of objects in any source file ?
Answer Question
| March 17, 2012 6:49 AM
AS/400, AS/400 objects, AS/400 Source Files
How can i get the count of objects in any source file ?
Answer Question
| March 17, 2012 6:49 AM
AS/400, AS/400 objects, AS/400 Source Files
iSeries: CPYing DIR from one place to another place with in box
I’m getting some error message while CPYing a DIR from one path to another DIR path…Does any body have idea on copying data between DIR path with in the system,If so pls let me know..? Error message is : Obect is Directory and Object is XXXXXXXXXXXX
Answer Question
| March 17, 2012 4:48 PM
AS/400 v6r1, iSeries V6R1
I’m getting some error message while CPYing a DIR from one path to another DIR path…Does any body have idea on copying data between DIR path with in the system,If so pls let me know..? Error message is : Obect is Directory and Object is XXXXXXXXXXXX
Answer Question
| March 17, 2012 4:48 PM
AS/400 v6r1, iSeries V6R1
Retrive System value in CCYYMMDDHHMMSS format?
Hi anyone tell me how to retrive system valule in format CCYYMMDDHHMMSS in which CC in centuary?
Answer Question
| March 17, 2012 6:32 AM
CL programming, CLLE
Hi anyone tell me how to retrive system valule in format CCYYMMDDHHMMSS in which CC in centuary?
Answer Question
| March 17, 2012 6:32 AM
CL programming, CLLE
Calcing quartiles using the median
I’m using this SQL to determine the median of a group of temperatures… select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end) >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2 + 1 If I want the 1st [...]
Answer Question
| March 17, 2012 11:04 PM
IBM i, SQL
I’m using this SQL to determine the median of a group of temperatures… select x.TEMP from QGPL/WEATHER1 x, QGPL/WEATHER1 y group by x.TEMP having sum(case when y.TEMP <= x.TEMP then 1 else 0 end) >=(count(*)+1)/2 and sum(case when y.TEMP >= x.TEMP then 1 else 0 end)>= count(*)/2 + 1 If I want the 1st [...]
Answer Question
| March 17, 2012 11:04 PM
IBM i, SQL
Iseries HMC
How to clear event logs using v7.7.4 SP1 would like command line information
Answer Question
| March 17, 2012 5:58 PM
HMC, HMC Event logs
How to clear event logs using v7.7.4 SP1 would like command line information
Answer Question
| March 17, 2012 5:58 PM
HMC, HMC Event logs
sqlrpgle-6
query to find n’th Highest salary in a file?
Answer Question
| March 17, 2012 6:56 AM
AS/400, SQLRPGLE
query to find n’th Highest salary in a file?
Answer Question
| March 17, 2012 6:56 AM
AS/400, SQLRPGLE
how to get to print setup when printserver is defaulted to?
how to get to print setup when printserver is defaulted to? Setting up several z400m and one of them, when attaching to the web interface ONLY gives ZebraNet print server and no way to get to the z400m printer configuration via the web interface. Brand new out of the box.
Answer Question
| March 17, 2012 9:02 PM
Printer Configuration, Zebra ZM400
how to get to print setup when printserver is defaulted to? Setting up several z400m and one of them, when attaching to the web interface ONLY gives ZebraNet print server and no way to get to the z400m printer configuration via the web interface. Brand new out of the box.
Answer Question
| March 17, 2012 9:02 PM
Printer Configuration, Zebra ZM400
Navigation from one sheet to another in AS400(RPGLE)
I have converted two physical files into one flat file.Afterthat I have converted that flat file to CSV file and got two physical files data in one excel file. But I need to write first phsical files data in sheet1 and second physical file data in sheet2 in same excel file.Is there any way [...]
Answer Question
| February 27, 2012 3:16 PM
CL, RPGLE
I have converted two physical files into one flat file.Afterthat I have converted that flat file to CSV file and got two physical files data in one excel file. But I need to write first phsical files data in sheet1 and second physical file data in sheet2 in same excel file.Is there any way [...]
Answer Question
| February 27, 2012 3:16 PM
CL, RPGLE
How to debug Movex explorer pgm?
Hi, Currently I’m working on Movex ERP (Using As/400 technology). In which RPG language is used. I’m facing some problem to explorer view so, I want to debug that pgm. Can anyone tell the process for debugging Explorer. Thanks,
Answer Question
| February 27, 2012 6:35 AM
Add new tag, AS400 RPGLE, Movex As/400, PGM
Hi, Currently I’m working on Movex ERP (Using As/400 technology). In which RPG language is used. I’m facing some problem to explorer view so, I want to debug that pgm. Can anyone tell the process for debugging Explorer. Thanks,
Answer Question
| February 27, 2012 6:35 AM
Add new tag, AS400 RPGLE, Movex As/400, PGM
Printek 4503 Configuration for I-Series
This printer is driving me nuts. Has anyone been able to config this to the I-Series. I tried 9100 direct and remote output queues and cannot get it to work.
Answer Question
| March 17, 2012 3:16 PM
AS 400, Printer Configuration
This printer is driving me nuts. Has anyone been able to config this to the I-Series. I tried 9100 direct and remote output queues and cannot get it to work.
Answer Question
| March 17, 2012 3:16 PM
AS 400, Printer Configuration
Change Logo on AS400 Signon Screen
Hi, I am new to this, I would like to change the logo on my AS400 screen, I know the source file and DSPF, but I am not sure how to change the Logo eventhough I knowthis can done using STRSDA. I can see the current logo using design screen,opt 12= design image..Can I make [...]
Answer Question
| March 19, 2012 1:25 PM
AS/400, AS/400 Screen
Hi, I am new to this, I would like to change the logo on my AS400 screen, I know the source file and DSPF, but I am not sure how to change the Logo eventhough I knowthis can done using STRSDA. I can see the current logo using design screen,opt 12= design image..Can I make [...]
Answer Question
| March 19, 2012 1:25 PM
AS/400, AS/400 Screen
Check special characters in a field filled with Arabic characters in AS400
Hi, I have a text field whcih can accomodate Arabic as well as English, I want to check for any special characters if Arabic is entered or vice versa. Thanks GAK
Answer Question
| March 17, 2012 7:12 AM
AS/400, as/400 rpg iseries
Hi, I have a text field whcih can accomodate Arabic as well as English, I want to check for any special characters if Arabic is entered or vice versa. Thanks GAK
Answer Question
| March 17, 2012 7:12 AM
AS/400, as/400 rpg iseries
Save Outq Spool Data
Is there a limit to the number of spool files that can be saved at a time from an outq using savobj *outq?
Answer Question
| March 17, 2012 7:54 PM
AS/400 Spool Files, iSeries 5.4.5
Is there a limit to the number of spool files that can be saved at a time from an outq using savobj *outq?
Answer Question
| March 17, 2012 7:54 PM
AS/400 Spool Files, iSeries 5.4.5
