AS/400 application menu
how to find all the menu’s that created using applications?
Answer Question
| May 9, 2012 3:38 PM
AS/400, WRKOBJ
how to find all the menu’s that created using applications?
Answer Question
| May 9, 2012 3:38 PM
AS/400, WRKOBJ
AS400 menu options help creation
It is DSPF with subfile that includes: Option# (up to 999, alpha-numeric) and option description(up to 30 chars.). Some options can start the other menu (nested). Thank you. yuriy44
Answer Question
| May 8, 2012 1:59 PM
AS/400, AS400/RPG, CLLE
It is DSPF with subfile that includes: Option# (up to 999, alpha-numeric) and option description(up to 30 chars.). Some options can start the other menu (nested). Thank you. yuriy44
Answer Question
| May 8, 2012 1:59 PM
AS/400, AS400/RPG, CLLE
AS/400 Query
I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can’t see how to convert the temperature to a character string either as the sign is ignored. Any other [...]
Answer Question
| May 8, 2012 11:55 AM
AS/400, AS/400 database, AS/400 Query
I use Query400 to output negative temperatures to a database file. The output file is currently created by the query at run time. The data is output as packed but I need the sign separate. I can’t see how to convert the temperature to a character string either as the sign is ignored. Any other [...]
Answer Question
| May 8, 2012 11:55 AM
AS/400, AS/400 database, AS/400 Query
user profile
how to get library list for perticuler user profile?
Answer Question
| May 9, 2012 6:09 AM
AS/400, AS400 RPGLE
how to get library list for perticuler user profile?
Answer Question
| May 9, 2012 6:09 AM
AS/400, AS400 RPGLE
Query Manager Report Forms
Is there a simple way to print a cover page using Query Manager like there is in regular query/400
Answer Question
| May 9, 2012 7:15 PM
AS/400, Query Manager
Is there a simple way to print a cover page using Query Manager like there is in regular query/400
Answer Question
| May 9, 2012 7:15 PM
AS/400, Query Manager
Sharing AS/400 folders
Hello all, Do i have to install Client Access in pc Client to work with AS400 folders?
Answer Question
| May 8, 2012 3:02 PM
AS/400, AS/400 Client Access, AS/400 Folders
Hello all, Do i have to install Client Access in pc Client to work with AS400 folders?
Answer Question
| May 8, 2012 3:02 PM
AS/400, AS/400 Client Access, AS/400 Folders
Cannot expand the folder
My manager gave me edit rights to her inbox & calendar and I received an email stating she gave me these permissions. I went into my account settings to add her to my mail folders and when I click on her name, I get the Cannont Expand the Folder error. I have the same persmissions [...]
Answer Question
| May 8, 2012 2:55 PM
Microsoft Office 2007, Microsoft Office Error Messages
My manager gave me edit rights to her inbox & calendar and I received an email stating she gave me these permissions. I went into my account settings to add her to my mail folders and when I click on her name, I get the Cannont Expand the Folder error. I have the same persmissions [...]
Answer Question
| May 8, 2012 2:55 PM
Microsoft Office 2007, Microsoft Office Error Messages
Error while using OVRDBF
Hi I am using OVRDBF command in my cl program in order to apply a particular select criteria on a database file in order to pass it to the RPGLE code. The syntax I used is as below: OVRDBF FILE(MYFILE) TOFILE(MYFILE) + MBR(MYFILE) OVRSCOPE(*JOB) SHARE(*YES) OPNQRYF FILE((MYFILE *FIRST *ONLY)) OPTION(*ALL) + QRYSLT(‘MYCODE *EQ [...]
Answer Question
| May 8, 2012 2:51 PM
AS/400, AS400 RPGLE, OVRDBF
Hi I am using OVRDBF command in my cl program in order to apply a particular select criteria on a database file in order to pass it to the RPGLE code. The syntax I used is as below: OVRDBF FILE(MYFILE) TOFILE(MYFILE) + MBR(MYFILE) OVRSCOPE(*JOB) SHARE(*YES) OPNQRYF FILE((MYFILE *FIRST *ONLY)) OPTION(*ALL) + QRYSLT(‘MYCODE *EQ [...]
Answer Question
| May 8, 2012 2:51 PM
AS/400, AS400 RPGLE, OVRDBF
LIKEDS with DIM() in RPGLE
Hi Gurus, I need some help. I have the following code and it can not be compiled. It says: *RNF7030 30 596700 The name or indicator ADDRESS is not defined. Here is my code: D sndemail pr Extpgm('SNDEMAIL') D subject 80A const D htmlmsg 5000a const D toaddrs likeds(emailaddrs) dim(20) D fromaddr 100a const D [...]
Answer Question
| May 10, 2012 11:07 AM
as400 v5r3, RPGLE Program
Hi Gurus, I need some help. I have the following code and it can not be compiled. It says: *RNF7030 30 596700 The name or indicator ADDRESS is not defined. Here is my code: D sndemail pr Extpgm('SNDEMAIL') D subject 80A const D htmlmsg 5000a const D toaddrs likeds(emailaddrs) dim(20) D fromaddr 100a const D [...]
Answer Question
| May 10, 2012 11:07 AM
as400 v5r3, RPGLE Program
SQL View
I need to create an sql view & do FTP of this view. CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename. In my text file i need a tab b/w each fields. But in the text i got there are no field seperators b/w field 1 & field 2. Is [...]
Answer Question
| May 8, 2012 10:19 AM
AS/400 SQL View
I need to create an sql view & do FTP of this view. CREATE VIEW palib/reshgjw AS SELECT WJWID as WJWID,char(WPEROD) as WPEROD,char(WCMPNY) as WCMPNY from libname/filename. In my text file i need a tab b/w each fields. But in the text i got there are no field seperators b/w field 1 & field 2. Is [...]
Answer Question
| May 8, 2012 10:19 AM
AS/400 SQL View
datagridview
I am using vb.net and access database. I have a datagridview with 20 rows and 5 columns( filed name in access table as follows: S.no,product_code,product_name,qty.rate).I want to update all datas which I entered in the datagridview to the concernd table.. Can you plz give me the code for updating database. table name: Iteminvtbl button name ( for [...]
Answer Question
| May 9, 2012 9:04 AM
Database
I am using vb.net and access database. I have a datagridview with 20 rows and 5 columns( filed name in access table as follows: S.no,product_code,product_name,qty.rate).I want to update all datas which I entered in the datagridview to the concernd table.. Can you plz give me the code for updating database. table name: Iteminvtbl button name ( for [...]
Answer Question
| May 9, 2012 9:04 AM
Database
Processing limit was reached
One of our customer Production server has Crystal Reports server 2008 SP1 installed along with Crystal Reports server Embedded 2008.This server has total of 9 RAS services running. There reports are generated and refreshed through a Crystal DOTNET API viewer. The issue with one particular report is when performing Generate/Refresh through the Crystal Viewer, once the [...]
Answer Question
| May 8, 2012 8:55 AM
Crystal Reports 2008, RAS
One of our customer Production server has Crystal Reports server 2008 SP1 installed along with Crystal Reports server Embedded 2008.This server has total of 9 RAS services running. There reports are generated and refreshed through a Crystal DOTNET API viewer. The issue with one particular report is when performing Generate/Refresh through the Crystal Viewer, once the [...]
Answer Question
| May 8, 2012 8:55 AM
Crystal Reports 2008, RAS
CREATE SQL VIEW
Can i provide a tab betwen two fields whicle selecting fields from a file to create an SQL view? I tried || and +. But is throwed me token not valid.
Answer Question
| May 8, 2012 8:51 AM
AS/400, AS/400 SQL View
Can i provide a tab betwen two fields whicle selecting fields from a file to create an SQL view? I tried || and +. But is throwed me token not valid.
Answer Question
| May 8, 2012 8:51 AM
AS/400, AS/400 SQL View
FTP Field seperator
Can we provide a tab or ‘~’ symbol between each fields in the text file while doing an FTP? I need a column seperator between two coulmns in my text File. It will be good if the column sepertaor can be a tab ot ‘~’ symbol.
Answer Question
| May 8, 2012 7:27 AM
FTP Column seperator
Can we provide a tab or ‘~’ symbol between each fields in the text file while doing an FTP? I need a column seperator between two coulmns in my text File. It will be good if the column sepertaor can be a tab ot ‘~’ symbol.
Answer Question
| May 8, 2012 7:27 AM
FTP Column seperator
PACKED FIELDS
How the packed field be represented in AS400? I see some special characters where the data type is packed. How can i see the actual value of the data in this packed field? I tried an F10 & F11. But finding the data in hex. IS there any way to get my data as it is? [...]
Answer Question
| May 8, 2012 7:07 AM
Packed field data
How the packed field be represented in AS400? I see some special characters where the data type is packed. How can i see the actual value of the data in this packed field? I tried an F10 & F11. But finding the data in hex. IS there any way to get my data as it is? [...]
Answer Question
| May 8, 2012 7:07 AM
Packed field data
enter SRTSQL Satements AS400
Hi, I have done an index by “create index……” and when I am trying to do aquery with STRSQL on that index I receive the following error: BKPPDAI1 in BKTEST not table, view, or physical file. This is my Statement: select *from bktest/BKPPDAI1 I am trying to fix the syntaxis but I can not make [...]
Answer Question
| May 7, 2012 3:46 PM
as400/DB2
Hi, I have done an index by “create index……” and when I am trying to do aquery with STRSQL on that index I receive the following error: BKPPDAI1 in BKTEST not table, view, or physical file. This is my Statement: select *from bktest/BKPPDAI1 I am trying to fix the syntaxis but I can not make [...]
Answer Question
| May 7, 2012 3:46 PM
as400/DB2
Selecting send connector while sending mail
Hello I have two “Internal relay” domains in Exchange 2010 For example a.com and b.com I would like to select “send connector 1″ while relaying mails come from a.com and I would like to select “send connector 2″ while relaying mails come from b.com Is that possible and How can I do that Thanks Erol [...]
Answer Question
| May 6, 2012 6:56 AM
Exchange 2010
Hello I have two “Internal relay” domains in Exchange 2010 For example a.com and b.com I would like to select “send connector 1″ while relaying mails come from a.com and I would like to select “send connector 2″ while relaying mails come from b.com Is that possible and How can I do that Thanks Erol [...]
Answer Question
| May 6, 2012 6:56 AM
Exchange 2010
Secure FTP for one User
I’m in the process of setting up Secure FTP over SSL for a Single User Profile “TESTFTP”.If i do enable of SSL FTP and assign certficates to FTP client from DCM. Everyone has to follow SSL ftp.Could anybody assist me in setting up SSL ftp for ONLY one user.? Currently no SSL is enabled in [...]
Answer Question
| June 22, 2012 6:47 AM
AS/400, Data, DCM, FTP, iSeries, SSL, User profiles
I’m in the process of setting up Secure FTP over SSL for a Single User Profile “TESTFTP”.If i do enable of SSL FTP and assign certficates to FTP client from DCM. Everyone has to follow SSL ftp.Could anybody assist me in setting up SSL ftp for ONLY one user.? Currently no SSL is enabled in [...]
Answer Question
| June 22, 2012 6:47 AM
AS/400, Data, DCM, FTP, iSeries, SSL, User profiles
How to Convert rdf to pdf
How to Convert more then one rdf to single pdf in report 6i
Answer Question
| June 26, 2012 6:28 AM
Report Program Generator
How to Convert more then one rdf to single pdf in report 6i
Answer Question
| June 26, 2012 6:28 AM
Report Program Generator
VBScript and Key down syntax
I am trying to run this program below. The portion that is commented out (the if statement) is not working. Obviously I’ve got the wrong syntax or it’s not possible. What I’m trying to do is to click F10 every 12 seconds until I hit the escape key, or until it has gone through it [...]
Answer Question
| May 5, 2012 3:51 AM
VBScript Statements, vbscript tips, vbscriptstatements
I am trying to run this program below. The portion that is commented out (the if statement) is not working. Obviously I’ve got the wrong syntax or it’s not possible. What I’m trying to do is to click F10 every 12 seconds until I hit the escape key, or until it has gone through it [...]
Answer Question
| May 5, 2012 3:51 AM
VBScript Statements, vbscript tips, vbscriptstatements
