Portfolio Assessment
Dear All, I am planning to do a portfolio assessment for our application which is developed in COBOL/400. Based on this portfolio assessmnet, we are going to finalize whether to re-architect the application or migrate. I am planning to submit below mentioned deliverables to architect group as an o/p of portfolio assessment: 1. Application [...]
Answer Question
| May 14, 2012 12:57 PM
AS/400, AS400/COBOL
Dear All, I am planning to do a portfolio assessment for our application which is developed in COBOL/400. Based on this portfolio assessmnet, we are going to finalize whether to re-architect the application or migrate. I am planning to submit below mentioned deliverables to architect group as an o/p of portfolio assessment: 1. Application [...]
Answer Question
| May 14, 2012 12:57 PM
AS/400, AS400/COBOL
Compare part of string to field
Hi. Hopefully a simple one but beyond my self-taught abilities in iSeries SQL. I have a file with one field containing customer order details including their purchase order reference such as ‘A1-123′. The first part of the PO reference is a branch identifier. Unfortunately, as it is a free text field, it is sometimes expressed [...]
Answer Question
| May 16, 2012 10:40 AM
iSeries SQL, iseries v5r4
Hi. Hopefully a simple one but beyond my self-taught abilities in iSeries SQL. I have a file with one field containing customer order details including their purchase order reference such as ‘A1-123′. The first part of the PO reference is a branch identifier. Unfortunately, as it is a free text field, it is sometimes expressed [...]
Answer Question
| May 16, 2012 10:40 AM
iSeries SQL, iseries v5r4
Which PTF is First?
Can i apply CUM,GRP, HIPERs and other single PTFs all at once with one image catalog? or first i need to apply GRP AND HIPERS and then CUM followed by IPL.? Which order will be the best practise ?
Answer Question
| May 16, 2012 10:11 AM
AS/400, PTF packages
Can i apply CUM,GRP, HIPERs and other single PTFs all at once with one image catalog? or first i need to apply GRP AND HIPERS and then CUM followed by IPL.? Which order will be the best practise ?
Answer Question
| May 16, 2012 10:11 AM
AS/400, PTF packages
question based on JOIN logical file.
I have one physical file having 4 members (multi members) inside it with account_no as key field name and one more simple physical file also has same key field name i.e. account_no. SO MY QUESTION IS CAN WE JOIN MULTI MEMBER PF AND SIMPLE PF ? IF YES THEN HOW ? IF NO THEN WHY [...]
Answer Question
| May 25, 2012 8:47 AM
AS/400, AS/400 logical file
I have one physical file having 4 members (multi members) inside it with account_no as key field name and one more simple physical file also has same key field name i.e. account_no. SO MY QUESTION IS CAN WE JOIN MULTI MEMBER PF AND SIMPLE PF ? IF YES THEN HOW ? IF NO THEN WHY [...]
Answer Question
| May 25, 2012 8:47 AM
AS/400, AS/400 logical file
Clear Leading ZERO’S
Hi, I am having a numeric field which is used in KLIST.I need to remove the leading zero’s for my numeric field.How i can do this.
Answer Question
| May 25, 2012 6:52 AM
AS/400, AS400 RPGLE
Hi, I am having a numeric field which is used in KLIST.I need to remove the leading zero’s for my numeric field.How i can do this.
Answer Question
| May 25, 2012 6:52 AM
AS/400, AS400 RPGLE
Pass table name to procedure including fields
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]
Answer Question
| May 16, 2012 5:55 AM
MySQL, MySQL Database
I want to do the following with a procedure: I have per user that has the same structure. The only difference is the table name. I need to be able to pass the table name to a procedure and retrieve data for that table. At the moment I have this: sp_getdata(id, givendate datetime,tablename varchar(200)) BEGIN [...]
Answer Question
| May 16, 2012 5:55 AM
MySQL, MySQL Database
Running multiple servers
well i want to execute servlets, asp code and php code the problem is cant able to execute all these three codes in one operating system, is it possible to execute these three. if i made three accounts for each and iam using the windows7 for servlets it is tomcat] for asp iis and php [...]
Answer Question
| May 14, 2012 10:05 AM
ASP, PHP, Windows 7
well i want to execute servlets, asp code and php code the problem is cant able to execute all these three codes in one operating system, is it possible to execute these three. if i made three accounts for each and iam using the windows7 for servlets it is tomcat] for asp iis and php [...]
Answer Question
| May 14, 2012 10:05 AM
ASP, PHP, Windows 7
ITKE spam
I’m just about fed up with the spam garbage allowed through this site. Twenty questions show up today on the first page of the IT Questions list. Two are duplicates. Two seem more or less appropriate where an actual IT-related question comes from someone who seems to have a legitimate problem or question. Five [...]
Answer Question
| May 25, 2012 11:59 PM
AS400 Windows DB2 security ITKE spam
I’m just about fed up with the spam garbage allowed through this site. Twenty questions show up today on the first page of the IT Questions list. Two are duplicates. Two seem more or less appropriate where an actual IT-related question comes from someone who seems to have a legitimate problem or question. Five [...]
Answer Question
| May 25, 2012 11:59 PM
AS400 Windows DB2 security ITKE spam
Get MYSQL data on iSeries
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…
Answer Question
| May 14, 2012 8:10 AM
AS400 iseries, Linux, MySQL
Datas are on a Linux server = mysql database and I want to transfert some datas to a DB2 database on iseries. At this time, I go throw Excel but sure we can do better !!…
Answer Question
| May 14, 2012 8:10 AM
AS400 iseries, Linux, MySQL
LANSA in MOCHASOFT
Hi, Just tO Learn and get feeling of LANSA while googling came across to http://home.solcon.nl/heijligers/ and copied file heybrow21.bin file to my local deskop now in this page( heybrow installation instructions) http://home.solcon.nl/heijligers/hbInstall.html in this page step no: 1 says On the PC, copy Heybrow21.bin from your download directory to IFS directory [mydirectory][/mydirectory]. But this is [...]
Answer Question
| May 25, 2012 6:48 AM
AS/400, LANSA
Hi, Just tO Learn and get feeling of LANSA while googling came across to http://home.solcon.nl/heijligers/ and copied file heybrow21.bin file to my local deskop now in this page( heybrow installation instructions) http://home.solcon.nl/heijligers/hbInstall.html in this page step no: 1 says On the PC, copy Heybrow21.bin from your download directory to IFS directory [mydirectory][/mydirectory]. But this is [...]
Answer Question
| May 25, 2012 6:48 AM
AS/400, LANSA
Lotus Notes 8.5 Replicator error: Invalid or nonexistent document
I am using a Lotus Notes 8.5.2 client on a Windows 7 computer in a corporate setting with a number of Domino servers, with two primary ones that I replicate between. I just recently had my OS upgraded from Windows XP. Nothing else changed, as far as I know, with my Lotus Notes (unless my [...]
Answer Question
| May 23, 2012 8:18 PM
Lotus Notes 8.5, Windows 7
I am using a Lotus Notes 8.5.2 client on a Windows 7 computer in a corporate setting with a number of Domino servers, with two primary ones that I replicate between. I just recently had my OS upgraded from Windows XP. Nothing else changed, as far as I know, with my Lotus Notes (unless my [...]
Answer Question
| May 23, 2012 8:18 PM
Lotus Notes 8.5, Windows 7
Oracle IR ISO error
Hi, I am trying to test the IR ISO (Internal Requisition and Internal sales Order) process. But when I run the ‘Create Intercompany AP Invoices’ in the requesting org, the record fails with following error “APP-INV-05708: Vendor and/or vendor site information not found Returned warning from extra function” Any ideas?
Answer Question
| May 14, 2012 4:13 PM
Oracle Apps 11i, Oracle error messages
Hi, I am trying to test the IR ISO (Internal Requisition and Internal sales Order) process. But when I run the ‘Create Intercompany AP Invoices’ in the requesting org, the record fails with following error “APP-INV-05708: Vendor and/or vendor site information not found Returned warning from extra function” Any ideas?
Answer Question
| May 14, 2012 4:13 PM
Oracle Apps 11i, Oracle error messages
Formula Workshop gives me an error but no description of the error…
Trying to run a report in Crystal Reports XI, and it pops up the Formula Workshop with the Error section populated with one of the formulas, but there’s absolutely no text anywhere telling me why it threw the error. Is there a way to find out what’s wrong?
Answer Question
| May 14, 2012 4:06 PM
Crystal Report XI, Crystal Reports form
Trying to run a report in Crystal Reports XI, and it pops up the Formula Workshop with the Error section populated with one of the formulas, but there’s absolutely no text anywhere telling me why it threw the error. Is there a way to find out what’s wrong?
Answer Question
| May 14, 2012 4:06 PM
Crystal Report XI, Crystal Reports form
How to change my email address for this application
I need to change my email address and when I edit my Account, it will not accept it unless I put in my handle. The Handle field is not input capable. How do I get it changed?
Answer Question
| May 14, 2012 3:34 PM
ITKE
I need to change my email address and when I edit my Account, it will not accept it unless I put in my handle. The Handle field is not input capable. How do I get it changed?
Answer Question
| May 14, 2012 3:34 PM
ITKE
connect as400 to oracle
How could I read tables on an external oracle database from an as400
Answer Question
| May 12, 2012 3:33 PM
Read oracle from as400
How could I read tables on an external oracle database from an as400
Answer Question
| May 12, 2012 3:33 PM
Read oracle from as400
Page down in QTP
I try to do a page down in QTP in am AS400 emulater but was unsucessful doing it
Answer Question
| May 11, 2012 2:34 PM
AS/400, QTP
I try to do a page down in QTP in am AS400 emulater but was unsucessful doing it
Answer Question
| May 11, 2012 2:34 PM
AS/400, QTP
How do I migrate user accounts from NT 4.0 to Win server 2008?
My company has finally realized our dinosaur won’t cut it today. I need to export all user accounts to the new server and am concerned that I cannot set the 2008 server as BDC and then promote it. Is it possible to export the user accounts to a file and then export them into the [...]
Answer Question
| May 11, 2012 1:25 PM
NT 4.0 Users
My company has finally realized our dinosaur won’t cut it today. I need to export all user accounts to the new server and am concerned that I cannot set the 2008 server as BDC and then promote it. Is it possible to export the user accounts to a file and then export them into the [...]
Answer Question
| May 11, 2012 1:25 PM
NT 4.0 Users
Unidentified network
I have an Acer laptop, on Windows Vista. Ive had problems with connecting to wireless for about 7-8 months now. It says connected but ‘unidentified network’. It connects via ethernet with no problems, and also to public hotspots but not home networks. Ive tried every setting possible, factory reset the laptop and it still will [...]
Answer Question
| June 4, 2012 12:51 PM
Unidentified network acer
I have an Acer laptop, on Windows Vista. Ive had problems with connecting to wireless for about 7-8 months now. It says connected but ‘unidentified network’. It connects via ethernet with no problems, and also to public hotspots but not home networks. Ive tried every setting possible, factory reset the laptop and it still will [...]
Answer Question
| June 4, 2012 12:51 PM
Unidentified network acer
I cannot access my Archive
I cannot access my Archive at Lotus 8.5, I have changed Lotus ID, and now I’m not authorized to access my archive which have been created on old ID, is it possible to somehow to get in to archive or at least to get emails from it? Thank you for your help.
Answer Question
| May 11, 2012 12:31 PM
Archive, Lotus 8.5
I cannot access my Archive at Lotus 8.5, I have changed Lotus ID, and now I’m not authorized to access my archive which have been created on old ID, is it possible to somehow to get in to archive or at least to get emails from it? Thank you for your help.
Answer Question
| May 11, 2012 12:31 PM
Archive, Lotus 8.5
SFLDSPCTL
What is the use of SFLDSPCTL, can I display a subfile without the control record format values, example is it possible to dislpay the subfile without the Main heading and the subfile fields heading which I have coded in the control record format?
Answer Question
| May 14, 2012 11:39 AM
SFLDSPCTL, Subfile
What is the use of SFLDSPCTL, can I display a subfile without the control record format values, example is it possible to dislpay the subfile without the Main heading and the subfile fields heading which I have coded in the control record format?
Answer Question
| May 14, 2012 11:39 AM
SFLDSPCTL, Subfile
