Using Decode in oracle sql query for Debtors Analysis Report
i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT, TRANDATE, POSTDATE, USER_ID, BATCH_ID, CONFIRMEDBY, CONFIRMDATE, COMMENTS, GLPOSTED, GLPOSTDATE, REVERSED, REVERSEDBY, REVERSEDATE, REVERSEREASON, REVERSEDTRAN_ID, [...]
Answer Question
| June 15, 2012 8:35 AM
SQL
i have a table called transactions in my oracle database which stores data for employees under particular employers. each member has an account and employer_id with transactions , the table has fields as below. TRAN_ID, TRANTYPE_ID, PENSION_ACCOUNT, EMPLOYER_ID, TRANAMT, SALARY, TAXEDAMOUNT, TRANDATE, POSTDATE, USER_ID, BATCH_ID, CONFIRMEDBY, CONFIRMDATE, COMMENTS, GLPOSTED, GLPOSTDATE, REVERSED, REVERSEDBY, REVERSEDATE, REVERSEREASON, REVERSEDTRAN_ID, [...]
Answer Question
| June 15, 2012 8:35 AM
SQL
CICS DB2 SCROLL LOGIC PROGRAM
I NEED TO IMPLEMENT SCROLL IN CICS AND DB2. PLEASE HELP ME TO SORT OUT THIS ISSUE. THANK YOU!!!!! SURESH
Answer Question
| June 14, 2012 6:46 AM
CICS programs
I NEED TO IMPLEMENT SCROLL IN CICS AND DB2. PLEASE HELP ME TO SORT OUT THIS ISSUE. THANK YOU!!!!! SURESH
Answer Question
| June 14, 2012 6:46 AM
CICS programs
File transfer
I would like to get the AS400 data into text file with no spaces between the fileds. Is there any way to do that?
Answer Question
| June 15, 2012 5:51 AM
AS/400 data transfer
I would like to get the AS400 data into text file with no spaces between the fileds. Is there any way to do that?
Answer Question
| June 15, 2012 5:51 AM
AS/400 data transfer
OS
how to install os to 100 systems at a time through LAN and not using SAN
Answer Question
| June 19, 2012 5:26 AM
OS
how to install os to 100 systems at a time through LAN and not using SAN
Answer Question
| June 19, 2012 5:26 AM
OS
Procedure interface and prototype
Why do we need both prototype and interface coded with almost no difference except that we can omit or use any name in prototype, need not to be an exact match with the interface. What is the exact use of these 2?
Answer Question
| June 14, 2012 5:13 AM
prototype
Why do we need both prototype and interface coded with almost no difference except that we can omit or use any name in prototype, need not to be an exact match with the interface. What is the exact use of these 2?
Answer Question
| June 14, 2012 5:13 AM
prototype
How to know which program uses a particular module?
Consider I have a module, and I have made some change to the module, (not a parameter change, but just a logic change). Now I have to update all the programs which uses this module. Without the help of any external tools or APIs is there any AS400 command similar to DSPPGMREF which will let [...]
Answer Question
| June 14, 2012 4:45 AM
AS/400, AS/400 commands
Consider I have a module, and I have made some change to the module, (not a parameter change, but just a logic change). Now I have to update all the programs which uses this module. Without the help of any external tools or APIs is there any AS400 command similar to DSPPGMREF which will let [...]
Answer Question
| June 14, 2012 4:45 AM
AS/400, AS/400 commands
Saving LF/PF to Tape
I’m trying to save the LF……but i’m not sure..so just tired in Google but Couldn’t get any good result for saving a LF/PF to a tape. Can any body explain me how to save Logical file and Physical files individually to a tape volume? like saving LF to MEDIA1 and saving PF to MEDIA2?
Answer Question
| June 19, 2012 3:17 AM
AS/400, logical file and Physical File
I’m trying to save the LF……but i’m not sure..so just tired in Google but Couldn’t get any good result for saving a LF/PF to a tape. Can any body explain me how to save Logical file and Physical files individually to a tape volume? like saving LF to MEDIA1 and saving PF to MEDIA2?
Answer Question
| June 19, 2012 3:17 AM
AS/400, logical file and Physical File
Bizarre Network/Internet Problem
Ok Experts I’ve got an interesting scenario. I do remote support for a property management company. We have multiple remote offices in NC and SC. I have 4-5 sites that are having a problem accessing our SaaS website which is http://westminstercomp.onesite.realpage.com/ There may be more sites but these the only ones reporting problems right now. [...]
Answer Question
| June 26, 2012 11:02 PM
Linksys Routers, Windows 7
Ok Experts I’ve got an interesting scenario. I do remote support for a property management company. We have multiple remote offices in NC and SC. I have 4-5 sites that are having a problem accessing our SaaS website which is http://westminstercomp.onesite.realpage.com/ There may be more sites but these the only ones reporting problems right now. [...]
Answer Question
| June 26, 2012 11:02 PM
Linksys Routers, Windows 7
wireless connection error
my laptop will not connect to wireless the window reads: Windows cannot configure thhis wirless connection[Br style=”color: #333333; font-family: Arial, Verdana, sans-serif; font-size: 14px; text-align: left;” />[Br style=”color: #333333; font-family: Arial, Verdana, sans-serif; font-size: 14px; text-align: left;” />If you have enabled another program to manage this wireless connection, use that software.[Br style=”color: #333333; font-family: Arial, [...]
Answer Question
| June 15, 2012 10:58 PM
Windows XP, Windows XP connection
my laptop will not connect to wireless the window reads: Windows cannot configure thhis wirless connection[Br style=”color: #333333; font-family: Arial, Verdana, sans-serif; font-size: 14px; text-align: left;” />[Br style=”color: #333333; font-family: Arial, Verdana, sans-serif; font-size: 14px; text-align: left;” />If you have enabled another program to manage this wireless connection, use that software.[Br style=”color: #333333; font-family: Arial, [...]
Answer Question
| June 15, 2012 10:58 PM
Windows XP, Windows XP connection
What kind of program I need to embed seach engines?
Need to know what kind of program do I need to embed a seach engine for my website. I want it for five differ boxes like for an address but want only to pull up that address. Do I need a php or sql or what?
Answer Question
| June 15, 2012 8:29 PM
Java Database Connectivity, JavaScript, PHP/MySQL
Need to know what kind of program do I need to embed a seach engine for my website. I want it for five differ boxes like for an address but want only to pull up that address. Do I need a php or sql or what?
Answer Question
| June 15, 2012 8:29 PM
Java Database Connectivity, JavaScript, PHP/MySQL
Create a macro for populating cells.
I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories and ways [...]
Answer Question
| June 15, 2012 6:09 PM
Microsoft Excel 2003, Microsoft Excel macros
I get raw data and need to clean it up. The data is a bunch of different products and the spreadsheet tracks the time it takes to process each individual product. The spreadsheet had about 100 different products. The first column is the product name, then the rest of the columns are subcategories and ways [...]
Answer Question
| June 15, 2012 6:09 PM
Microsoft Excel 2003, Microsoft Excel macros
printing SW3
I Thanks, George have Songworks and try to print my composition. What program can I use?
Answer Question
| June 13, 2012 5:50 PM
printing SW3
I Thanks, George have Songworks and try to print my composition. What program can I use?
Answer Question
| June 13, 2012 5:50 PM
printing SW3
Retrieving Subfile Size in RPGLE
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Hi Is there any way for us to retrieve subfile size in RPGLE code instead of hard coding it by seeing from the display file. -Vivek
Answer Question
| June 14, 2012 4:08 PM
RPG ILE, Subfile Size
Library list in Batch job
How can we set up a library list for a batch job?
Answer Question
| June 13, 2012 10:55 AM
Batch jobs
How can we set up a library list for a batch job?
Answer Question
| June 13, 2012 10:55 AM
Batch jobs
Service program can be deleted after having a reference to the Service program?
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
I have a program which refer to a service program, now if the service program gets deleted,any impact? I know a module obj can be deleted after we create a program from that module as it is bind by copy. But since the service program is a bind by reference, will that delete cause any [...]
Answer Question
| June 14, 2012 10:52 AM
Service program
Embedded SQL Update Query
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Suppose I have a file with empid and telephone number, I realised the telephone number value is not correct for some 3-4 employee ids. I have a backup file for this file and it has the correct telephone number value . I need to write an SQL querry to correct the wrong telephone number by [...]
Answer Question
| June 15, 2012 10:42 AM
Embedded SQL
Return more than one parameter from a subprocedure
I want to return Name, DOB and Place of Birth from a Subprocedure. Is it possible to return more than one parameter at a time? Any method other than using the same parameter as input and output?
Answer Question
| June 14, 2012 10:38 AM
Subprocedure
I want to return Name, DOB and Place of Birth from a Subprocedure. Is it possible to return more than one parameter at a time? Any method other than using the same parameter as input and output?
Answer Question
| June 14, 2012 10:38 AM
Subprocedure
BRMS Select Device (Q1ASLTDEV) API
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
Hello, I found in the BRMS manual that the BRMS select device API lets you select a device to allocate or deallocate, or to select search values such as location and media class to locate and allocate an available device for BRMS media input or output operations. Well, I don’t understand very well how and [...]
Answer Question
| June 13, 2012 10:24 AM
API, BRMS
AS/400 Domino Backups.
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
At times backup hangs up with message as Backup failed due to Pointer not set for location referenced. Backup waits in JobQ and it is not getting in Media library. Kindly help
Answer Question
| June 13, 2012 8:49 AM
AS/400, AS/400 Domino
opendns.com certficate on exchange
Hi. When i open outlook it gives me secirity sertficate error opendns.com . Buttons Yes, NO and view certficate. What may be a problem? how can i recolve it?
Answer Question
| June 20, 2012 8:08 AM
Microsoft Outlook 2007, Microsoft Outlook error messages, Micrososft Exchange 2010
Hi. When i open outlook it gives me secirity sertficate error opendns.com . Buttons Yes, NO and view certficate. What may be a problem? how can i recolve it?
Answer Question
| June 20, 2012 8:08 AM
Microsoft Outlook 2007, Microsoft Outlook error messages, Micrososft Exchange 2010
