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
SQL TAGS
Why am failling when am using mysql to create database and am using the exactly tags?
Answer Question
| May 27, 2012 6:54 AM
MySQL, MySQL Database
Why am failling when am using mysql to create database and am using the exactly tags?
Answer Question
| May 27, 2012 6:54 AM
MySQL, MySQL Database
how to prevent values
how to prevent these values &<>” in a field
Answer Question
| May 15, 2012 5:46 AM
AS400 RPGLE, RPGLE values
how to prevent these values &<>” in a field
Answer Question
| May 15, 2012 5:46 AM
AS400 RPGLE, RPGLE values
PTFs a level back
I need to download level back PTFs i.e -1 level of Current Cumulative,Group and HIPER PTFs.When i tried to download from Fix Central,I Could see all latest Available PTFs.But as per my shop policy i need to apply only -1 level PTFs(Not very latest ). Can anybody help me finding a Way to download the [...]
Answer Question
| May 16, 2012 5:39 AM
AS/400, iSeries, PTFs
I need to download level back PTFs i.e -1 level of Current Cumulative,Group and HIPER PTFs.When i tried to download from Fix Central,I Could see all latest Available PTFs.But as per my shop policy i need to apply only -1 level PTFs(Not very latest ). Can anybody help me finding a Way to download the [...]
Answer Question
| May 16, 2012 5:39 AM
AS/400, iSeries, PTFs
arrays in rpg
can we sort a character array in descending order?(compile time array)
Answer Question
| May 11, 2012 1:19 AM
AS400 iseries, AS400. RPG
can we sort a character array in descending order?(compile time array)
Answer Question
| May 11, 2012 1:19 AM
AS400 iseries, AS400. RPG
Forms Compile question
Is there a difference between compiling a form through the developer client on my windows machine and compiling it on a unix server. I compiled it on my windows developer client and ftp’d it to the unix server and when I try and run it through EBS, it says it is not a valid forms [...]
Answer Question
| May 18, 2012 11:01 PM
EBS, Oracle Forms 6i, Unix Servers
Is there a difference between compiling a form through the developer client on my windows machine and compiling it on a unix server. I compiled it on my windows developer client and ftp’d it to the unix server and when I try and run it through EBS, it says it is not a valid forms [...]
Answer Question
| May 18, 2012 11:01 PM
EBS, Oracle Forms 6i, Unix Servers
