select command
i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.
Answer Question
| March 22, 2012 7:49 AM
Oracle, Oracle commands, Oracle Table
i would like to collect informations from oracle date table through select query financial year wise my financial year starts from01 jul and ends on 30 jun. my task is to collect total number of entries from last ten financial years wise.
Answer Question
| March 22, 2012 7:49 AM
Oracle, Oracle commands, Oracle Table
Access 2003 SQL Query for grouping
Team… I need your help… SELECT Pickerid, Sum(Currentweight) AS TotalWeight, IIf(pickerhours=0,0,TotalWeight/pickerhours) FROM mergeddatabase WHERE ((Currentdate) between [Enter First Date Required:] and [Enter Last Date Required:]) GROUP BY pickerid, pickerhours; I have a access database (2003) single Table (mergeddatabase) with thousands of entries.. This is a query to work out picking rates. The criteria is a [...]
Answer Question
| March 25, 2012 3:49 AM
Microsoft Access 2003, SQL Query
Team… I need your help… SELECT Pickerid, Sum(Currentweight) AS TotalWeight, IIf(pickerhours=0,0,TotalWeight/pickerhours) FROM mergeddatabase WHERE ((Currentdate) between [Enter First Date Required:] and [Enter Last Date Required:]) GROUP BY pickerid, pickerhours; I have a access database (2003) single Table (mergeddatabase) with thousands of entries.. This is a query to work out picking rates. The criteria is a [...]
Answer Question
| March 25, 2012 3:49 AM
Microsoft Access 2003, SQL Query
get value from column using a column name string
Hi I have 2 lists.. The first contains rows with mapping values inlcuding column name, xcord, ycord The second contains the data I need to map.. I need to get the value in each row using the column name from the first row.. for example List<SheetMappings> smaps = new <SheetMappings>(); Foreach(maplist m in mlist) { [...]
Answer Question
| March 21, 2012 10:53 PM
C#, Visual Studio 2010
Hi I have 2 lists.. The first contains rows with mapping values inlcuding column name, xcord, ycord The second contains the data I need to map.. I need to get the value in each row using the column name from the first row.. for example List<SheetMappings> smaps = new <SheetMappings>(); Foreach(maplist m in mlist) { [...]
Answer Question
| March 21, 2012 10:53 PM
C#, Visual Studio 2010
User utilization
My previous supervisor ran a report to display CPU utilization by user profile over a certain time period. I am trying to find out how to run this query. Can someone please help with directions?
Answer Question
| March 21, 2012 7:38 PM
CPU Utilization, iSeries v7r1
My previous supervisor ran a report to display CPU utilization by user profile over a certain time period. I am trying to find out how to run this query. Can someone please help with directions?
Answer Question
| March 21, 2012 7:38 PM
CPU Utilization, iSeries v7r1
Restore default settings of open list
I basically lost everything. All that’s left is search, history, composite applications, web browser, getting started, and home. I want mail, calendar, applications (databases), etc back. Help!!!
Answer Question
| March 20, 2012 4:25 PM
Lotus Notes 8, Lotus Notes errors
I basically lost everything. All that’s left is search, history, composite applications, web browser, getting started, and home. I want mail, calendar, applications (databases), etc back. Help!!!
Answer Question
| March 20, 2012 4:25 PM
Lotus Notes 8, Lotus Notes errors
SPCAUT = *NONE
What can you do on the command line if you have it but have SPCAUT = *NONE. I’m just trying to understand the risks and the benefit of having it = *NONE. My understanding is that there is no risk as you cannot do anything, but if that is the case, can I set the [...]
Answer Question
| March 22, 2012 3:36 PM
Identity management, Security management
What can you do on the command line if you have it but have SPCAUT = *NONE. I’m just trying to understand the risks and the benefit of having it = *NONE. My understanding is that there is no risk as you cannot do anything, but if that is the case, can I set the [...]
Answer Question
| March 22, 2012 3:36 PM
Identity management, Security management
AS 400 printer file shading of record format
How do I shade (excel style) a whole record format within a printerfile? The record format may appear many times on a page and of course on different lines. Should I create an overlay, if so, how do I create the overlay to print in variable positions? I am using RPG to produce the report [...]
Answer Question
| March 25, 2012 3:15 PM
AS/400, AS400/RPG
How do I shade (excel style) a whole record format within a printerfile? The record format may appear many times on a page and of course on different lines. Should I create an overlay, if so, how do I create the overlay to print in variable positions? I am using RPG to produce the report [...]
Answer Question
| March 25, 2012 3:15 PM
AS/400, AS400/RPG
Autoprint to PDF Printer
Does anyone know if there is a script (VBS, BAT or otherwise) that will send a requested file (xls, doc, txt) to a local installed PDF printer and render it without user intervention?
Answer Question
| March 20, 2012 2:30 PM
VBScript, VBScript Functions
Does anyone know if there is a script (VBS, BAT or otherwise) that will send a requested file (xls, doc, txt) to a local installed PDF printer and render it without user intervention?
Answer Question
| March 20, 2012 2:30 PM
VBScript, VBScript Functions
AS400 Barcode
Hello, When I used apw(ADVANCE PRINT WRITER)to create a barcdoe in cdoe39 style,if the field have the blank on the end of the field,the right mark ‘*’ will be print output,but the mark ‘*’ is used to show the end of field in the code39 style. Would someone can tell me the reason and how [...]
Answer Question
| March 22, 2012 3:24 AM
AS/400, AS400 printing issue, OS/400 V5.4
Hello, When I used apw(ADVANCE PRINT WRITER)to create a barcdoe in cdoe39 style,if the field have the blank on the end of the field,the right mark ‘*’ will be print output,but the mark ‘*’ is used to show the end of field in the code39 style. Would someone can tell me the reason and how [...]
Answer Question
| March 22, 2012 3:24 AM
AS/400, AS400 printing issue, OS/400 V5.4
s36 files and environment is lost
i have program that work under s36 environmetn , … when user try to login it says user must login under s36 environment when i try anyl command related to s36 such as strs36 or strs36prc or what ever it reply ” file not found (file is not a part of qssp lib ) when [...]
Answer Question
| March 20, 2012 9:07 PM
i5/OS, iSeries partitioning
i have program that work under s36 environmetn , … when user try to login it says user must login under s36 environment when i try anyl command related to s36 such as strs36 or strs36prc or what ever it reply ” file not found (file is not a part of qssp lib ) when [...]
Answer Question
| March 20, 2012 9:07 PM
i5/OS, iSeries partitioning
Windows 7 profiles disappear
I have over 300 Win7 images deployed and a high percentage of them come back with new default profiles being created. The old profile is still on the machine but we need to merge the profiles to repair this. Anyone have ideas on why this happens?
Answer Question
| March 20, 2012 7:38 PM
SCCM, Windows 7, Windows 7 profiles
I have over 300 Win7 images deployed and a high percentage of them come back with new default profiles being created. The old profile is still on the machine but we need to merge the profiles to repair this. Anyone have ideas on why this happens?
Answer Question
| March 20, 2012 7:38 PM
SCCM, Windows 7, Windows 7 profiles
Solaris/SPARC to Linux/x86
What have been your experiences migrating your Solaris/SPARC applications to a Linux/x86 platform?
Answer Question
| March 20, 2012 6:16 PM
Migrations
What have been your experiences migrating your Solaris/SPARC applications to a Linux/x86 platform?
Answer Question
| March 20, 2012 6:16 PM
Migrations
Turn an Email URL into a Clickable Button
I often send emails to the rest of the employees when I create a new page in our Wiki. Instead of sending the boring URL, I’d like to turn the link into a colorful button. (Just to show them I know some Lotus tricks). I’ve done it before, but now I can’t remember what I [...]
Answer Question
| March 21, 2012 2:51 PM
Lotus hotspot, Lotus Notes 8.5.2
I often send emails to the rest of the employees when I create a new page in our Wiki. Instead of sending the boring URL, I’d like to turn the link into a colorful button. (Just to show them I know some Lotus tricks). I’ve done it before, but now I can’t remember what I [...]
Answer Question
| March 21, 2012 2:51 PM
Lotus hotspot, Lotus Notes 8.5.2
CLRPFM
When PF is Kept opened in One session that is I have done runqry on a PF ,and in the other session , if I try to do CLRPFM , it is not allowing .So if i want to delete the records of the fie if it is kept opened , what can be done [...]
Answer Question
| March 19, 2012 12:35 PM
CLRPFM, PF file
When PF is Kept opened in One session that is I have done runqry on a PF ,and in the other session , if I try to do CLRPFM , it is not allowing .So if i want to delete the records of the fie if it is kept opened , what can be done [...]
Answer Question
| March 19, 2012 12:35 PM
CLRPFM, PF file
as/400 INFDS
by using INFDS i do not want to write duplicate record into PF what is the requirements for that?
Answer Question
| March 19, 2012 7:29 AM
AS400 Data Definitions, AS400 iseries, INFDS
by using INFDS i do not want to write duplicate record into PF what is the requirements for that?
Answer Question
| March 19, 2012 7:29 AM
AS400 Data Definitions, AS400 iseries, INFDS
migrate from oracle 9 to oracle 11
Can one migrate from oracle9 to oracle11 without migrating to oracle 10? If yes, what premigration settings are required?
Answer Question
| March 20, 2012 4:18 AM
Oracle 11, Oracle 9, Oracle migration
Can one migrate from oracle9 to oracle11 without migrating to oracle 10? If yes, what premigration settings are required?
Answer Question
| March 20, 2012 4:18 AM
Oracle 11, Oracle 9, Oracle migration
how to copy tables between two libraries without repeat cpyf command using script?
I need to copy tables from library to another on the same iSeries v7.1, is there a script to copy multible tables without repeat cpyf command???
Answer Question
| March 20, 2012 8:17 PM
CPYF, iSeries v7.1
I need to copy tables from library to another on the same iSeries v7.1, is there a script to copy multible tables without repeat cpyf command???
Answer Question
| March 20, 2012 8:17 PM
CPYF, iSeries v7.1
Internet Access through Cisco Remote VPN
Hi, Im having major issues in our corporate network, to make it short i had to delete all remote VPN’s on our ASA 5520 runing 7.4 IOS. I have recreated the VPN’s using the VPN Wizard using L2TP. Issue: The VPN Works fine i can access all internal resources but the issue is that the [...]
Answer Question
| March 27, 2012 11:04 AM
Cisco VPN, L2TP, VPN
Hi, Im having major issues in our corporate network, to make it short i had to delete all remote VPN’s on our ASA 5520 runing 7.4 IOS. I have recreated the VPN’s using the VPN Wizard using L2TP. Issue: The VPN Works fine i can access all internal resources but the issue is that the [...]
Answer Question
| March 27, 2012 11:04 AM
Cisco VPN, L2TP, VPN
How to Insert Picture in Excel Report through Oracle
I have a table Name Emp_master. In this table having a column Pic_path varchar2(100). In this column employee picture path capture like ‘d:emp_pictureJohn.jpg’. I want to generate a report in Excel through Oracle having column like Emp_Code, Emp_Name & Emp_Picture. Please help
Answer Question
| March 27, 2012 10:34 AM
Oracle 6, Oracle Reports
I have a table Name Emp_master. In this table having a column Pic_path varchar2(100). In this column employee picture path capture like ‘d:emp_pictureJohn.jpg’. I want to generate a report in Excel through Oracle having column like Emp_Code, Emp_Name & Emp_Picture. Please help
Answer Question
| March 27, 2012 10:34 AM
Oracle 6, Oracle Reports
Unable to Edit objects by command.
I am unable to trim or dimension objects in a drawing of mine. It was working one second, and now when I select a command and snap to a point it would do anything. Has anyone experienced this before?
Answer Question
| March 19, 2012 8:00 PM
AutoCAD, AutoCAD 2012
I am unable to trim or dimension objects in a drawing of mine. It was working one second, and now when I select a command and snap to a point it would do anything. Has anyone experienced this before?
Answer Question
| March 19, 2012 8:00 PM
AutoCAD, AutoCAD 2012
