Oracle 9i data dictionary definition & informational SQL queries?
I am using Oracle 9i on a specific application that was designed back in 2000 — no supporting documentation, very little training and I’m new to Oracle and sql. I’m currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can modfiy so I’m [...]
Answer Question
| January 11, 2013 8:10 AM
Oracle 9i, Oracle 9i query
I am using Oracle 9i on a specific application that was designed back in 2000 — no supporting documentation, very little training and I’m new to Oracle and sql. I’m currently using Toad for Oracle which allows me to create query templates. Toad for Oracle has existing sql templates which I can modfiy so I’m [...]
Answer Question
| January 11, 2013 8:10 AM
Oracle 9i, Oracle 9i query
Increasing Domino server performence
Hi all, What is the steps for Domino server maintenance tasks and how to increase the Domino server performance. I am a Jr. Lotus Notes admin…please let me know immediately.
Answer Question
| January 11, 2013 5:32 AM
Lotus Domino, Lotus Domino server
Hi all, What is the steps for Domino server maintenance tasks and how to increase the Domino server performance. I am a Jr. Lotus Notes admin…please let me know immediately.
Answer Question
| January 11, 2013 5:32 AM
Lotus Domino, Lotus Domino server
Print SAP PO by User ID
Can I print a purchase order by user id? The print programs I have investigated only print by purchase org. Unfortunately, we only have one purchase org.
Answer Question
| January 11, 2013 3:55 AM
SAP, SAP PO
Can I print a purchase order by user id? The print programs I have investigated only print by purchase org. Unfortunately, we only have one purchase org.
Answer Question
| January 11, 2013 3:55 AM
SAP, SAP PO
365 flavors of Unix
Which flavor of Linux do you use for your workstation?
Answer Question
| January 11, 2013 10:06 PM
Linux, Unix
Which flavor of Linux do you use for your workstation?
Answer Question
| January 11, 2013 10:06 PM
Linux, Unix
Best way to store the data
Hi friends, at my current work they need a solution to store really a huge amount of data. It could be more 8tb. Most importantly they are working with SAS and retrieving data is become really hard for them. I know servers and databases are a good solution but no budget for it. Could you [...]
Answer Question
| January 11, 2013 9:22 PM
Data storage, Storage
Hi friends, at my current work they need a solution to store really a huge amount of data. It could be more 8tb. Most importantly they are working with SAS and retrieving data is become really hard for them. I know servers and databases are a good solution but no budget for it. Could you [...]
Answer Question
| January 11, 2013 9:22 PM
Data storage, Storage
Object inactivity timer
Can I change the system time value the tells the system when to compress a file based on inactivity.
Answer Question
| January 10, 2013 8:08 PM
AS/400, AS/400 objects
Can I change the system time value the tells the system when to compress a file based on inactivity.
Answer Question
| January 10, 2013 8:08 PM
AS/400, AS/400 objects
WRKOUTQ CMD key F20
A user has a menu option to display an output queue. When I hit F20 in this option, it displays the Work with All writers screen. When she hits F20 it displays the work with printers screen (like F22 also does). She confirmed that the same thing occurs on different PCs. She also checked the [...]
Answer Question
| January 10, 2013 5:48 PM
AS/400, iSeries, WRKOUTQ
A user has a menu option to display an output queue. When I hit F20 in this option, it displays the Work with All writers screen. When she hits F20 it displays the work with printers screen (like F22 also does). She confirmed that the same thing occurs on different PCs. She also checked the [...]
Answer Question
| January 10, 2013 5:48 PM
AS/400, iSeries, WRKOUTQ
Outlook 2010 Crash
Outlook 2010 crashes when we receive a meeting invite. Person is a delegate and this only happens when she receives invites from delegates. Running Windows 7 and PGP.
Answer Question
| January 10, 2013 5:08 PM
Microsoft Outlook 2010, Microsoft Outlook meetings
Outlook 2010 crashes when we receive a meeting invite. Person is a delegate and this only happens when she receives invites from delegates. Running Windows 7 and PGP.
Answer Question
| January 10, 2013 5:08 PM
Microsoft Outlook 2010, Microsoft Outlook meetings
Is this really the end for the PC?
In 2012, smartphone and tablet shipments surpassed PC sales for the first time in history. With these new numbers, many experts believe that they are watching the death of the once powerful PC. Do you think this is really the end for the PC? Does it have any chance of regaining its prior glory?
Answer Question
| January 25, 2013 5:05 PM
Mobile, PC, Tablet
In 2012, smartphone and tablet shipments surpassed PC sales for the first time in history. With these new numbers, many experts believe that they are watching the death of the once powerful PC. Do you think this is really the end for the PC? Does it have any chance of regaining its prior glory?
Answer Question
| January 25, 2013 5:05 PM
Mobile, PC, Tablet
OUTQ for an user profile
An user profile named xxxxxx having *WRKSTN as value for its OUTQ and printer device. Where we can define the OUTQ for a particular work station?
Answer Question
| January 10, 2013 3:03 PM
AS/400, AS/400 administration
An user profile named xxxxxx having *WRKSTN as value for its OUTQ and printer device. Where we can define the OUTQ for a particular work station?
Answer Question
| January 10, 2013 3:03 PM
AS/400, AS/400 administration
Not allowing forms to load for printing
Will not allow tax forms from the state to load for printing. It starts, but instantly shuts down the internet connection to the site. Forms are printed through Adobe and I have Microsoft XP for home use.
Answer Question
| January 10, 2013 2:51 PM
Adobe, Microsoft XP
Will not allow tax forms from the state to load for printing. It starts, but instantly shuts down the internet connection to the site. Forms are printed through Adobe and I have Microsoft XP for home use.
Answer Question
| January 10, 2013 2:51 PM
Adobe, Microsoft XP
Incrementing a key field without autonumber
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
I want to use a primary key field in format AAA9999999. Can I get the numeric part of the field to automatically increment to the next number in the range?
Answer Question
| January 10, 2013 11:36 AM
Microsoft Access 2007, Microsoft Access 2010
Suggested contacts
How do I turn on suggested contacts?
Answer Question
| January 10, 2013 10:28 AM
Microsoft Outlook 2011, Microsoft Outlook contacts
How do I turn on suggested contacts?
Answer Question
| January 10, 2013 10:28 AM
Microsoft Outlook 2011, Microsoft Outlook contacts
MIMIX DB Error clearing
Hi, How to clear the DB error in MIMIX Replication. I got some error in the DB option. Can anyone tell me how to clear that error? -Karuna
Answer Question
| January 10, 2013 9:49 AM
AS/400, MIMIX
Hi, How to clear the DB error in MIMIX Replication. I got some error in the DB option. Can anyone tell me how to clear that error? -Karuna
Answer Question
| January 10, 2013 9:49 AM
AS/400, MIMIX
MS Excel Macro imput
How to pause Macro execution for input of e.g. a Range to go to after resume?
Answer Question
| January 10, 2013 8:20 AM
Microsoft Excel, Microsoft Office
How to pause Macro execution for input of e.g. a Range to go to after resume?
Answer Question
| January 10, 2013 8:20 AM
Microsoft Excel, Microsoft Office
1 gigabyte = ? megabytes
1 gigabyte = ? megabytes
Answer Question
| January 10, 2013 7:48 AM
Gigabyte, Megabyte
1 gigabyte = ? megabytes
Answer Question
| January 10, 2013 7:48 AM
Gigabyte, Megabyte
Need to print PDF of length 198 generated by spool of same size
Earlier length of printer file was 132.Now some more fields are added and hence I have increase size till 198. After program execution, spool is being generated fine, but when converting it to PDF, the extra fields are being cropped. How can I generate PDF till length at least to 160 length. What extra setting [...]
Answer Question
| January 10, 2013 7:12 AM
AS/400, RPG, Spool file
Earlier length of printer file was 132.Now some more fields are added and hence I have increase size till 198. After program execution, spool is being generated fine, but when converting it to PDF, the extra fields are being cropped. How can I generate PDF till length at least to 160 length. What extra setting [...]
Answer Question
| January 10, 2013 7:12 AM
AS/400, RPG, Spool file
How to know whether the CSV extraction to PF happened today
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
I have a requirement like this. I have 2 separate program which is called as part of daily job. I need to extract a CSV data onto an AS/400 physical file and this file is being used in both the programs. I need to put the call to extract the CSV in any of the [...]
Answer Question
| January 10, 2013 6:31 AM
AS/400, CSV, Physical File
Outlook calendar appointments
When I put an appointment in Outlook calendar and set the start time, it says AM then the finishing time is PM but it defaults to AM.
Answer Question
| January 10, 2013 6:20 AM
Microsoft Outlook, Microsoft Outlook Calendar
When I put an appointment in Outlook calendar and set the start time, it says AM then the finishing time is PM but it defaults to AM.
Answer Question
| January 10, 2013 6:20 AM
Microsoft Outlook, Microsoft Outlook Calendar
Converting julian date with CL on the AS400
Can anyone help me with correcting the following code? I believe the error is in the /* CONVERT TO 30 DAYS AGO */ area, but I can’t see it. ********************************************************************************* DCL &TODAY *CHAR 6 DCL &LESS30 *CHAR 6 DCL &MBRDATE *CHAR 5 DCL VAR(&MBRDAT2) TYPE(*DEC) LEN(5 0) /* CONVERT TODAY’S DATE TO JULIAN */ RTVSYSVAL [...]
Answer Question
| January 10, 2013 1:47 AM
AS/400, CL
Can anyone help me with correcting the following code? I believe the error is in the /* CONVERT TO 30 DAYS AGO */ area, but I can’t see it. ********************************************************************************* DCL &TODAY *CHAR 6 DCL &LESS30 *CHAR 6 DCL &MBRDATE *CHAR 5 DCL VAR(&MBRDAT2) TYPE(*DEC) LEN(5 0) /* CONVERT TODAY’S DATE TO JULIAN */ RTVSYSVAL [...]
Answer Question
| January 10, 2013 1:47 AM
AS/400, CL
