The most-watched IT questions this week: Nov. 24, 2009
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
Is this a question? Is it relevant to post it here in Home > IT Answers > AS/400 > The most-watched IT questions this week: Nov.... just wondering!
6810 pts.
Delete and Update in Query Magager
I do not believe QM supports updates. You should switch to use the RUNSQLSTM. ======================================================= Run STRQM and take option 10 (Work with Query Manager profiles). Position to the user profile running the QM queries; select option 2=Change. Scroll to the end of...
I do not believe QM supports updates. You should switch to use the RUNSQLSTM. ======================================================= Run STRQM and take option 10 (Work with Query Manager profiles). Position to the user profile running the QM queries; select option 2=Change. Scroll to the end of...
Display Report Preview on full screen
You have to call the report with a parameter named MAXIMIZE (i.e. add this parameter to your parameter list). Something like this: add_parameter(myParamList,'MAXIMIZE',Text_Parameter,'YES');
You have to call the report with a parameter named MAXIMIZE (i.e. add this parameter to your parameter list). Something like this: add_parameter(myParamList,'MAXIMIZE',Text_Parameter,'YES');
Upgrade the Oracle Client to 10i from 8.1 without losing database connectivity?
If your actual database is version 8.1, then you can't! The highest client that will still connect to an 8.1 database is 9i, so you either have to use that, or upgrade your database. If your database is a higher version, then you can just install the latest client on your machine, in which case,...
If your actual database is version 8.1, then you can't! The highest client that will still connect to an 8.1 database is 9i, so you either have to use that, or upgrade your database. If your database is a higher version, then you can just install the latest client on your machine, in which case,...
MS SQL Server to Oracle Applications
Sounds like a perfect job for a SQL Server Integration Services package.
Sounds like a perfect job for a SQL Server Integration Services package.
Community Announcement: Cash in your Knowledge Points for an Amazon gift card
Ok for redeem my points now
Ok for redeem my points now
pl/slq procedures - POSITIVE and POSITIVEN as IN OUT parameters
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition. You should use POSITIVE for the out paramter instead.
The POSITIVEN type is allowed for IN paramaters only, as the initial value of an OUT parameter is NULL by definition. You should use POSITIVE for the out paramter instead.
Invoking a webpage from JDE World 7.3
Why pass the data from the green screen to the web page? Why not just use something like CGIDEV2 or one of several commercial applications to display the data on a web page in the first place? You can set up Client Access to use hot spots to let people click on a link on your green screen app to...
Why pass the data from the green screen to the web page? Why not just use something like CGIDEV2 or one of several commercial applications to display the data on a web page in the first place? You can set up Client Access to use hot spots to let people click on a link on your green screen app to...
DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks
We recently got this suggestion from a reader: "You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we're running OS/400 V5R2." -- Michelle ===================================================== If the field being transferred is a CHAR field, then...
We recently got this suggestion from a reader: "You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we're running OS/400 V5R2." -- Michelle ===================================================== If the field being transferred is a CHAR field, then...
CPYTOPCD filename length limitation
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, where these limitations do...
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, where these limitations do...
Error installing linux on Dell Poweredge 2950
If the drivers for your disks / raid arrays are not in the installation initrd, you'll have to get the linux drivers from Dell and add them during the installation. http://lmgtfy.com/?q=sles+9+add+driver+during+installation
If the drivers for your disks / raid arrays are not in the installation initrd, you'll have to get the linux drivers from Dell and add them during the installation. http://lmgtfy.com/?q=sles+9+add+driver+during+installation
Configuring listener.ora
You don't actually start listener.ora, listener.ora is just a configuration file providing information about your listener. The command to start the listener is "lsnrctl start <listener name>" . On any unix or linux o/s, I prefer to name the listeners, since there are times when I have...
You don't actually start listener.ora, listener.ora is just a configuration file providing information about your listener. The command to start the listener is "lsnrctl start <listener name>" . On any unix or linux o/s, I prefer to name the listeners, since there are times when I have...
SQL Server 2005 is running slow
You'll need to correctly index the table to work for the query. The columns in the WHERE clause should be the columns in the index. The columns which are returned but not in the WHERE clause should be included columns. Indexing is not necessarily the right answer and indexes applied under the...
You'll need to correctly index the table to work for the query. The columns in the WHERE clause should be the columns in the index. The columns which are returned but not in the WHERE clause should be included columns. Indexing is not necessarily the right answer and indexes applied under the...
How can automatically execute a oracle process
Are you talking about stored procedures? Does this help? Oracle® Database Administrator's Guide - Jobs
Are you talking about stored procedures? Does this help? Oracle® Database Administrator's Guide - Jobs
sql query
To give you a specific query for the results would require table and column names and specifics concerning their definitions. From the content of your question, it appears that you know the calculations necessary, you just need to plug in the column names for the variables you have listed. You'll...
To give you a specific query for the results would require table and column names and specifics concerning their definitions. From the content of your question, it appears that you know the calculations necessary, you just need to plug in the column names for the variables you have listed. You'll...
Oracle 9i install failure
Yes, 9i and personal 9i are different versions. You have not listed your operating system. I am presuming it is some flavor of windows. The software you are installing needs to be the release for your particular operating environment, so double check the compatability of the software with your...
Yes, 9i and personal 9i are different versions. You have not listed your operating system. I am presuming it is some flavor of windows. The software you are installing needs to be the release for your particular operating environment, so double check the compatability of the software with your...
About Time
A lot more info is needed... There are so many date / time functions available. Also are you taking inputs directly or selecting from tables? Here are a few to get you started: SELECT TO_DATE('01/01/1900 00:59:59','mm/dd/yy hh24:mi:ss') , SYSDATE , to_char(sysdate, 'HH:MM:SS') ...
A lot more info is needed... There are so many date / time functions available. Also are you taking inputs directly or selecting from tables? Here are a few to get you started: SELECT TO_DATE('01/01/1900 00:59:59','mm/dd/yy hh24:mi:ss') , SYSDATE , to_char(sysdate, 'HH:MM:SS') ...
Oracle usernames
Short answer is RTFM, but from http://faq.programmerworld.net/database/installing-oracle-10g.html "Note: Oracle 10g still keeps scott / tiger username and password (UID=scott, PWD=tiger) from the old version of oracle. In the old version of oracle, scott/tiger user ID is available by default, but...
Short answer is RTFM, but from http://faq.programmerworld.net/database/installing-oracle-10g.html "Note: Oracle 10g still keeps scott / tiger username and password (UID=scott, PWD=tiger) from the old version of oracle. In the old version of oracle, scott/tiger user ID is available by default, but...
