asp usage to 90%.. how can i check and bring asp use down
Try WRKJRN After you detatch the receivers you will want to save them Then you can delete them — actually you can delete them without saving them but that’s not a good idea. Phil I like to use Disk Space Tasks to determine where to start when I need to clean up a system. You [...]
View Answer
| July 11, 2009 9:00 AM
AS/400 ASP, AS/400 performance, ASP
Try WRKJRN After you detatch the receivers you will want to save them Then you can delete them — actually you can delete them without saving them but that’s not a good idea. Phil I like to use Disk Space Tasks to determine where to start when I need to clean up a system. You [...]
View Answer
| July 11, 2009 9:00 AM
AS/400 ASP, AS/400 performance, ASP
Business Process Automation tools
My boss and I are currently authoring a software that uses DB2 data in conjunction with Crystal Reports, and some label software to automate creation and printing of labels within the company. We also have a load of scripts and macros running which are initiated several ways. -Schmidtw
View Answer
| July 10, 2009 6:11 PM
Automation, Business Process Automation, Development, Macros, Report Automation
My boss and I are currently authoring a software that uses DB2 data in conjunction with Crystal Reports, and some label software to automate creation and printing of labels within the company. We also have a load of scripts and macros running which are initiated several ways. -Schmidtw
View Answer
| July 10, 2009 6:11 PM
Automation, Business Process Automation, Development, Macros, Report Automation
Java error 25009
I would suggest a few things: Check what’s currently on your system, and see if the step you are trying to make up is not on the upgrade path of your current. Stop the installer, and try it again. Download from another source and install. Hope this helps! -Schmidtw
View Answer
| July 10, 2009 5:53 PM
Error 25009, Java, unzipping core files
I would suggest a few things: Check what’s currently on your system, and see if the step you are trying to make up is not on the upgrade path of your current. Stop the installer, and try it again. Download from another source and install. Hope this helps! -Schmidtw
View Answer
| July 10, 2009 5:53 PM
Error 25009, Java, unzipping core files
Mirroring from a production environment to a DR environment
You can create a single cluster that spans the two sites. This requires that both SANs are able to talk to each other and do async replication between them. The more common technique is to use database mirroring between the two sites.
View Answer
| July 9, 2009 9:26 PM
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring
You can create a single cluster that spans the two sites. This requires that both SANs are able to talk to each other and do async replication between them. The more common technique is to use database mirroring between the two sites.
View Answer
| July 9, 2009 9:26 PM
Disaster Recovery, Production environments, SQL Server 2005, SQL Server 2005 mirroring, SQL Server backup and restore, SQL Server Mirroring
Datacenter Project
I’m not sure as to what scale you are going for here or how many end users you will have on staff but I might be able to give you some ideas for the creation. I’ve seen data centers at multiple universities, XO communications, local ISP providers, and even call centers that have only 6 [...]
View Answer
| July 9, 2009 4:49 PM
Data Center Cost, Data center design, Data center planning, DataCenter, Project cost estimation, Template
I’m not sure as to what scale you are going for here or how many end users you will have on staff but I might be able to give you some ideas for the creation. I’ve seen data centers at multiple universities, XO communications, local ISP providers, and even call centers that have only 6 [...]
View Answer
| July 9, 2009 4:49 PM
Data Center Cost, Data center design, Data center planning, DataCenter, Project cost estimation, Template
Create a file with formulas on the iSeries and send to Excel.
I am not sure if you code using RPG, but if so you can use the HSSF API’s created by Scott Klement to create fully formatted Excel spreadsheets from an RPG program. This includes formulas, as well as lots of other formatting options. There are three articles that he wrote to describe the basics. If [...]
View Answer
| July 9, 2009 1:51 PM
AS/400, iSeries, Microsoft Excel, SQL
I am not sure if you code using RPG, but if so you can use the HSSF API’s created by Scott Klement to create fully formatted Excel spreadsheets from an RPG program. This includes formulas, as well as lots of other formatting options. There are three articles that he wrote to describe the basics. If [...]
View Answer
| July 9, 2009 1:51 PM
AS/400, iSeries, Microsoft Excel, SQL
Why 2 different functions?
Answered my own question. I removed the ?OpenElement from the URL string, gave Annonmous reader access and modified the code as follows. The attachement opens and then updates the fields all without having to extract the file to the local PC or have the attachment stored on the document. function launch_attachment (loc) // loc is [...]
View Answer
| July 8, 2009 11:08 PM
ActiveX, Domino 6.5, JavaScript
Answered my own question. I removed the ?OpenElement from the URL string, gave Annonmous reader access and modified the code as follows. The attachement opens and then updates the fields all without having to extract the file to the local PC or have the attachment stored on the document. function launch_attachment (loc) // loc is [...]
View Answer
| July 8, 2009 11:08 PM
ActiveX, Domino 6.5, JavaScript
JAVA and i5
Have you checked out all the configurators on the ibm web site? Lots of info there, and the chance to use the configuration tools the grown ups use.. - maybe even buy yourself a developer box at special prices… - No affiliation yada yada . . ..
View Answer
| July 8, 2009 3:36 PM
ERP, i5, Java, OS/400
Have you checked out all the configurators on the ibm web site? Lots of info there, and the chance to use the configuration tools the grown ups use.. - maybe even buy yourself a developer box at special prices… - No affiliation yada yada . . ..
View Answer
| July 8, 2009 3:36 PM
ERP, i5, Java, OS/400
Connecting to Domino Server.
You’ll have to use the COM interface of Lotus Notes. Is it on a server? If so, you will initialize a session with the user name and password and go from there. It is quite easy really. Make sure your project has a reference to the Lotus Domino COM objects. sample for VB – works [...]
View Answer
| July 7, 2009 8:51 PM
C#, Domino Server, Lotus development
You’ll have to use the COM interface of Lotus Notes. Is it on a server? If so, you will initialize a session with the user name and password and go from there. It is quite easy really. Make sure your project has a reference to the Lotus Domino COM objects. sample for VB – works [...]
View Answer
| July 7, 2009 8:51 PM
C#, Domino Server, Lotus development
Using the query to filter out the specifics
NLIKE ‘%mexT%’ Case sensitive
View Answer
| July 7, 2009 5:37 PM
Query
NLIKE ‘%mexT%’ Case sensitive
View Answer
| July 7, 2009 5:37 PM
Query
T-shirt giveaway: Have you uploaded your profile pic yet?
added my photo. dave
View Answer
| July 7, 2009 2:30 PM
AS/400, Development, Exchange, ITKE, Lotus Domino, Microsoft Windows, Networking, Security, SQL Server, Storage, Virtualization
added my photo. dave
View Answer
| July 7, 2009 2:30 PM
AS/400, Development, Exchange, ITKE, Lotus Domino, Microsoft Windows, Networking, Security, SQL Server, Storage, Virtualization
SQL embedded in RPGLE
You wll want to create SQL indexes on each file based on the where field(s) I believe that you can run these interactively in Navigator and capture the necessary indexes. With the correct indexes your SQL commands will find the record to update very much like a chain would. Phil
View Answer
| July 7, 2009 11:50 AM
DB2, iSeries, performance, RPGLE, SQL
You wll want to create SQL indexes on each file based on the where field(s) I believe that you can run these interactively in Navigator and capture the necessary indexes. With the correct indexes your SQL commands will find the record to update very much like a chain would. Phil
View Answer
| July 7, 2009 11:50 AM
DB2, iSeries, performance, RPGLE, SQL
Read Lotus Email in asp.net
This could be achieved by using the COM interface into Domino from the ASP page. It would require that a Notes client be installed on the server however, as the ability to initialize a session is based on the Notes ID referenced in the Notes.INI on the server running the script (it can be Domino [...]
View Answer
| July 3, 2009 9:56 PM
ASP.NET, Lotus Mail, Lotus Notes, VB.NET
This could be achieved by using the COM interface into Domino from the ASP page. It would require that a Notes client be installed on the server however, as the ability to initialize a session is based on the Notes ID referenced in the Notes.INI on the server running the script (it can be Domino [...]
View Answer
| July 3, 2009 9:56 PM
ASP.NET, Lotus Mail, Lotus Notes, VB.NET
Delete OLD files from Table not having date or timestamp
I’m not aware of any method that automagically keeps track of that information. If you do not see a field(s) that relates to a create Date/Time stamp, then have a problem. Are you journaling the file? That would keep track of changes made to the file. Use DSPFD and search for ‘jour’. <pre> File is [...]
View Answer
| July 3, 2009 12:45 PM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL
I’m not aware of any method that automagically keeps track of that information. If you do not see a field(s) that relates to a create Date/Time stamp, then have a problem. Are you journaling the file? That would keep track of changes made to the file. Use DSPFD and search for ‘jour’. <pre> File is [...]
View Answer
| July 3, 2009 12:45 PM
AS/400, as400/DB2, DB/400, DB2, DB2/400, delete sql, DELETE statement, SQL
Can you use Windows Variable names within Lotus Notes
I verified that Windows Explorer will parse the %username% variable, so windows scripting engines will probably do the same. The format I used is the same as you gave in the question, (\myserver%username%my_mail.nsf) so there may be another issue, such as permissions to view a file on the Notes server. Notes has a robust security [...]
View Answer
| July 2, 2009 8:34 PM
Lotus Notes, Windows Variable Names
I verified that Windows Explorer will parse the %username% variable, so windows scripting engines will probably do the same. The format I used is the same as you gave in the question, (\myserver%username%my_mail.nsf) so there may be another issue, such as permissions to view a file on the Notes server. Notes has a robust security [...]
View Answer
| July 2, 2009 8:34 PM
Lotus Notes, Windows Variable Names
AS400 Physical file conversion to xml file
Scott Klement wrote an open source XML parser. You can find it here: http://www.scottklement.com/expat/ Also, you may find some examples here: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books_web/c0925076168.htm and here: http://www.google.com/search?hl=en&q=xml+%2Brpgle&aq=f&oq=&aqi=g1
View Answer
| July 2, 2009 1:54 PM
AS/400 import/export, Physical File, RPG/400, RPGLE, XML
Scott Klement wrote an open source XML parser. You can find it here: http://www.scottklement.com/expat/ Also, you may find some examples here: http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/books_web/c0925076168.htm and here: http://www.google.com/search?hl=en&q=xml+%2Brpgle&aq=f&oq=&aqi=g1
View Answer
| July 2, 2009 1:54 PM
AS/400 import/export, Physical File, RPG/400, RPGLE, XML
does HP TestDirector support TTCN TCI
Hi Richard, as far as I know, <b>NO</b>! However, our <a href=”http://www.testingtech.com/products/ttplugins.php”>TTplugin-QualityCenter</a> , from Testing Technologies, closes this gap. It brings the TTCN-3 world provided by TTworkbench together with test management world as provided by Quality Center. To speak a little bit more technically. Typically the referenced interfaces (here TCI) are provided by the TTCN-3 [...]
View Answer
| July 2, 2009 11:10 AM
ETSI ES 201 873-6, HP TestDirector, TTCN-3 Control Interface
Hi Richard, as far as I know, <b>NO</b>! However, our <a href=”http://www.testingtech.com/products/ttplugins.php”>TTplugin-QualityCenter</a> , from Testing Technologies, closes this gap. It brings the TTCN-3 world provided by TTworkbench together with test management world as provided by Quality Center. To speak a little bit more technically. Typically the referenced interfaces (here TCI) are provided by the TTCN-3 [...]
View Answer
| July 2, 2009 11:10 AM
ETSI ES 201 873-6, HP TestDirector, TTCN-3 Control Interface
ActiveBatch
You need to refine your question a bit. Do you mean copy jobs from one queue to another? If so, that’s simple association which can be handled by “drag and drop” (select the job(s) and then drag them to the target queue and drop). Do you mean copy jobs as in “clone” jobs? If so, [...]
View Answer
| July 1, 2009 7:45 PM
Active Batch job scheduler, ActiveBatch, Job scheduling, Job scheduling software
You need to refine your question a bit. Do you mean copy jobs from one queue to another? If so, that’s simple association which can be handled by “drag and drop” (select the job(s) and then drag them to the target queue and drop). Do you mean copy jobs as in “clone” jobs? If so, [...]
View Answer
| July 1, 2009 7:45 PM
Active Batch job scheduler, ActiveBatch, Job scheduling, Job scheduling software
Convert column from Number(9) to varchar2(3) in SQL
In Oracle, I would use the bulk collect capability, as follows: 1. Create a copy table of the source (empty with no data), as in: create table MyClone as select * from OldTable where 0=1; 2. Alter the table to change the data type of the column from Number(9) to Varchar2(3) alter table MyClone modify [...]
View Answer
| July 1, 2009 3:50 PM
SQL, SQL tables, VARCHAR
In Oracle, I would use the bulk collect capability, as follows: 1. Create a copy table of the source (empty with no data), as in: create table MyClone as select * from OldTable where 0=1; 2. Alter the table to change the data type of the column from Number(9) to Varchar2(3) alter table MyClone modify [...]
View Answer
| July 1, 2009 3:50 PM
SQL, SQL tables, VARCHAR
DTS: Export to Excel
Hello You can try using the transformation between SQL server to MS Excel. If this doesnt work than use ActiveX script to generate the MS Excel file which will able to handle dynamic column names. This will involve writing macro which will select the required columns from table in SQL and put the same in [...]
View Answer
| July 1, 2009 3:25 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft Excel
Hello You can try using the transformation between SQL server to MS Excel. If this doesnt work than use ActiveX script to generate the MS Excel file which will able to handle dynamic column names. This will involve writing macro which will select the required columns from table in SQL and put the same in [...]
View Answer
| July 1, 2009 3:25 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft Excel
