Overlay Printing Issue
I have one overlay that two programs use. When testing I have a very simple CL program with one OVRDBF and two program calls one of which I have commented out because I swithch calls when testing. In trying to print a voucher the main voucher program works fine, I then modify the CL by [...]
Answer Question
| March 22, 2012 3:40 PM
CL Program, iSeries Overlay Printing Issue
I have one overlay that two programs use. When testing I have a very simple CL program with one OVRDBF and two program calls one of which I have commented out because I swithch calls when testing. In trying to print a voucher the main voucher program works fine, I then modify the CL by [...]
Answer Question
| March 22, 2012 3:40 PM
CL Program, iSeries Overlay Printing Issue
Set Page orientation
Can anyone help identify how to set the Page Layout Orientation of an XLSX file in VBS? I am using the below script example for reference. Set obj = CreateObject("Excel.Application") Set objWorkbook = obj.Workbooks.Open("C:pathtest.xlsx") obj.ActiveSheet.PageSetup.Orientation = xlLandscape obj.ActiveWorkbook.Saveas "C:pathtest.xlsx" obj.ActiveWorkbook.Close Thank you.
Answer Question
| March 21, 2012 3:35 PM
VBScript, VBScript Functions
Can anyone help identify how to set the Page Layout Orientation of an XLSX file in VBS? I am using the below script example for reference. Set obj = CreateObject("Excel.Application") Set objWorkbook = obj.Workbooks.Open("C:pathtest.xlsx") obj.ActiveSheet.PageSetup.Orientation = xlLandscape obj.ActiveWorkbook.Saveas "C:pathtest.xlsx" obj.ActiveWorkbook.Close Thank you.
Answer Question
| March 21, 2012 3:35 PM
VBScript, VBScript Functions
ORA-03127: no new operations allowed until the active operation ends
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error [...]
Answer Question
| March 22, 2012 12:13 PM
ORA-03127, Oracle 11g, Oracle Reports 10g
Good Morning, Since oracle 10g and even after upgrading to oracle 11g , e keep getting an oracle error: ORA-03127: no new operations allowed until the active operation ends, in relation to a diferent db table, every time the error occurs. including db tables that have maintenunce every day. can anyone tell me why this error [...]
Answer Question
| March 22, 2012 12:13 PM
ORA-03127, Oracle 11g, Oracle Reports 10g
Can i install Linux by double along with win 7
Can i install Linux along with win 7 as win 7 is in system and now looking to install Linux parallel ???? please guide me
Answer Question
| June 1, 2012 9:34 AM
Linux installation, Windows 7
Can i install Linux along with win 7 as win 7 is in system and now looking to install Linux parallel ???? please guide me
Answer Question
| June 1, 2012 9:34 AM
Linux installation, Windows 7
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
