COGNOS reports – SQL file
Which COGNOS tool are you using? If it is IMPROMPTU then go to CatalogQueryProfile TabSQL Radio Button If you are in ReportNet open up ReportStudio, click on QueryExplorer, select the Query you want and on the left hand side in the Properties there is a generated SQL property.
View Answer
| March 11, 2005 10:51 AM
Development, Help Desk, Software Quality Assurance, Storage, Tech support
Which COGNOS tool are you using? If it is IMPROMPTU then go to CatalogQueryProfile TabSQL Radio Button If you are in ReportNet open up ReportStudio, click on QueryExplorer, select the Query you want and on the left hand side in the Properties there is a generated SQL property.
View Answer
| March 11, 2005 10:51 AM
Development, Help Desk, Software Quality Assurance, Storage, Tech support
PMP transitioning from tech oriented projects to business oriented projects
Hi It was good to see, your experience. But let me make one point clear, PMI methodologies is platform independant. The process is modified to suit the client’s need and also at same time quality should not be lost, that is best & tough changle in anyone’s career. I agree partical that if a person [...]
View Answer
| March 11, 2005 9:42 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance
Hi It was good to see, your experience. But let me make one point clear, PMI methodologies is platform independant. The process is modified to suit the client’s need and also at same time quality should not be lost, that is best & tough changle in anyone’s career. I agree partical that if a person [...]
View Answer
| March 11, 2005 9:42 AM
Business/IT alignment, Customer relationship management applications, Data analysis, Development, ERP, Financial services applications, Human resource applications, Lifecycle development, Microsoft Windows, Oracle, PeopleSoft, Projects, Salesforce.com, SalesLogix, SAP, Sarbanes-Oxley Act, Siebel, Software Quality Assurance
Workstation security
User accounts do not have permission to edit the registry this is why SUS will not run under a user account …however you can set up SUS to run under the Administrator account from the user account. “Run this program as….” and select “always run this program as….” Your updates will be able to run. [...]
View Answer
| March 10, 2005 7:26 AM
DataCenter, Development
User accounts do not have permission to edit the registry this is why SUS will not run under a user account …however you can set up SUS to run under the Administrator account from the user account. “Run this program as….” and select “always run this program as….” Your updates will be able to run. [...]
View Answer
| March 10, 2005 7:26 AM
DataCenter, Development
FTP to an Iseries 400 automated from within Microsoft Access
I am not an Access person, but the iSeries handles FTP easily. I’ve created a number of scripts to put files from Windows PCs to the iSeries. Example of a text file I use as a script: userid password lcd lcd clientssontagpgms cd /qsys.lib/test.lib bin put shlib.savf code.file quit Some notes: The user and password [...]
View Answer
| March 10, 2005 6:39 AM
AS/400, Desktop management applications, Development, Programming Languages
I am not an Access person, but the iSeries handles FTP easily. I’ve created a number of scripts to put files from Windows PCs to the iSeries. Example of a text file I use as a script: userid password lcd lcd clientssontagpgms cd /qsys.lib/test.lib bin put shlib.savf code.file quit Some notes: The user and password [...]
View Answer
| March 10, 2005 6:39 AM
AS/400, Desktop management applications, Development, Programming Languages
3d drawing
Depending on what level of detail and accuracy you need this is either going to be easy or painful! If you are not using a 3D API like OpenGL or DirectX, you need to do the math yourself to project your 3D drawing onto a 2D surface and then just use the normal line drawing [...]
View Answer
| March 10, 2005 3:42 AM
Development, IT architecture
Depending on what level of detail and accuracy you need this is either going to be easy or painful! If you are not using a 3D API like OpenGL or DirectX, you need to do the math yourself to project your 3D drawing onto a 2D surface and then just use the normal line drawing [...]
View Answer
| March 10, 2005 3:42 AM
Development, IT architecture
Listing USER tables in DB2
Will depend on whether you have access to the appropriate DB2 catalog table. Sql is SELECT TCREATOR, TTNAME , DELETEAUTH, INSERTAUTH , SELECTAUTH, UPDATEAUTH FROM SYSIBM.SYSTABAUTH WHERE GRANTEE IN (‘PUBLIC’,'whatever your userid is’)
View Answer
| March 9, 2005 3:41 PM
SQL
Will depend on whether you have access to the appropriate DB2 catalog table. Sql is SELECT TCREATOR, TTNAME , DELETEAUTH, INSERTAUTH , SELECTAUTH, UPDATEAUTH FROM SYSIBM.SYSTABAUTH WHERE GRANTEE IN (‘PUBLIC’,'whatever your userid is’)
View Answer
| March 9, 2005 3:41 PM
SQL
Domino Database Last Used
If the database is marked to be listed in the domain catalog (database properties) then the Domain Catalog will show the creationdate, last modified and activity along with alot of useful info. The activiy includes changes from scheduled agents.
View Answer
| March 9, 2005 7:49 AM
Database, DB2, Development, Domino Designer, Lotus Domino, Oracle
If the database is marked to be listed in the domain catalog (database properties) then the Domain Catalog will show the creationdate, last modified and activity along with alot of useful info. The activiy includes changes from scheduled agents.
View Answer
| March 9, 2005 7:49 AM
Database, DB2, Development, Domino Designer, Lotus Domino, Oracle
Slow PL/SQL query
So we can assume that your query is doing a full table scan(s)? Have you looked at the execution plan? So either it is meant to take long, i.e. it returns most of the rows, or the where clause is not making use of indexed columns. Get an execution plan and you’ll see where it’s [...]
View Answer
| March 8, 2005 10:51 AM
Oracle 8i, SQL
So we can assume that your query is doing a full table scan(s)? Have you looked at the execution plan? So either it is meant to take long, i.e. it returns most of the rows, or the where clause is not making use of indexed columns. Get an execution plan and you’ll see where it’s [...]
View Answer
| March 8, 2005 10:51 AM
Oracle 8i, SQL
Facsimile Support for the As/400
Sounds like you hava a library list issue. The vendor would probably be a better resource for this.
View Answer
| March 8, 2005 10:24 AM
Development
Sounds like you hava a library list issue. The vendor would probably be a better resource for this.
View Answer
| March 8, 2005 10:24 AM
Development
TIMESTAMP to DATFMT(*USA) conversion in RPGLE.
D DsplyField S D DatFmt(*USA) /free DsplyField = %date(%subst(TSTAMP:1:10):*ISO); /end-free
View Answer
| March 8, 2005 8:18 AM
Development
D DsplyField S D DatFmt(*USA) /free DsplyField = %date(%subst(TSTAMP:1:10):*ISO); /end-free
View Answer
| March 8, 2005 8:18 AM
Development
PRINTING SAMPLES OF ISERIES FONTS
I believe the FONTNAME keyword works with *AFPDS type print files. When you create the print file, specifiy DEVTYPE(*AFPDS). That should allow you to use the keyword correctly.
View Answer
| March 8, 2005 8:11 AM
AS/400, Development
I believe the FONTNAME keyword works with *AFPDS type print files. When you create the print file, specifiy DEVTYPE(*AFPDS). That should allow you to use the keyword correctly.
View Answer
| March 8, 2005 8:11 AM
AS/400, Development
Returning Multiple result sets to Excel
Create a temp table in the SP, populate it with the results of the query, then append the sum’s etc. You may have to add a dummy column or two that will be populated by the sum’s but not by the query. Then do a final SELECT * FROM temp table, kill the temp table [...]
View Answer
| March 7, 2005 5:30 PM
SQL, T-SQL
Create a temp table in the SP, populate it with the results of the query, then append the sum’s etc. You may have to add a dummy column or two that will be populated by the sum’s but not by the query. Then do a final SELECT * FROM temp table, kill the temp table [...]
View Answer
| March 7, 2005 5:30 PM
SQL, T-SQL
VB .Net ComboBox Problem
The code you provided is very simple and straight forward, it works just fine in the Form_Load event of a windows application. Check the properties of the control and where are you populating it (i.e. in which event), if you are still having problems could you provide more details? Such as if you are working [...]
View Answer
| March 7, 2005 10:36 AM
Development
The code you provided is very simple and straight forward, it works just fine in the Form_Load event of a windows application. Check the properties of the control and where are you populating it (i.e. in which event), if you are still having problems could you provide more details? Such as if you are working [...]
View Answer
| March 7, 2005 10:36 AM
Development
Formats of textboxes
TextBox1.Text = Format(YourNumber,”Currency”)
View Answer
| March 7, 2005 9:11 AM
Development, VB.NET
TextBox1.Text = Format(YourNumber,”Currency”)
View Answer
| March 7, 2005 9:11 AM
Development, VB.NET
linking an iseries data base to microsoft access using odbc
Not claiming any expertise in this area, here is what I’d look at: 1). Is the “identity” of the ODBC link consistent with the “identity” of the journaling process? In many situations like this, what you want to do in a production environment is have a “thread” on the AS400 which acts as a server [...]
View Answer
| March 5, 2005 11:35 AM
Development
Not claiming any expertise in this area, here is what I’d look at: 1). Is the “identity” of the ODBC link consistent with the “identity” of the journaling process? In many situations like this, what you want to do in a production environment is have a “thread” on the AS400 which acts as a server [...]
View Answer
| March 5, 2005 11:35 AM
Development
Class Instatiation through External Class File
If I understand what you’ve set up, it sounds like you should have a base class with the common method and then have the other classes extend the base class. Then all you do is instantiate the desired class and call the comon mehtod. You’re other option is to use the implements option to make [...]
View Answer
| March 3, 2005 4:50 PM
Development
If I understand what you’ve set up, it sounds like you should have a base class with the common method and then have the other classes extend the base class. Then all you do is instantiate the desired class and call the comon mehtod. You’re other option is to use the implements option to make [...]
View Answer
| March 3, 2005 4:50 PM
Development
CLOB – Fetch out of sequence
You may get this error when you use “select from .. update” statement after issuing a commit. Once commit is executed, the cursor status is no longer valid and hence the error. You have two options. Do not commit or re-open the cursor. HTH
View Answer
| March 3, 2005 11:26 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML
You may get this error when you use “select from .. update” statement after issuing a commit. Once commit is executed, the cursor status is no longer valid and hence the error. You have two options. Do not commit or re-open the cursor. HTH
View Answer
| March 3, 2005 11:26 AM
Database Management Systems, Development, J2EE, Java, Lifecycle development, Oracle, Oracle 10g, Oracle 8i, Oracle 9i, SQL, XML
Domino mail: Dealing with leavers/resignations; forwarding
Once you delete a user from the Domino directory, the server should stop receiving email for that user. The oly way youhave to view pass email for this user is to restore the mail file if the mail file has been delete.
View Answer
| March 2, 2005 12:00 PM
Career development, DataCenter, Development, Help Desk, Lifecycle development, Security, Software Quality Assurance, Tech support
Once you delete a user from the Domino directory, the server should stop receiving email for that user. The oly way youhave to view pass email for this user is to restore the mail file if the mail file has been delete.
View Answer
| March 2, 2005 12:00 PM
Career development, DataCenter, Development, Help Desk, Lifecycle development, Security, Software Quality Assurance, Tech support
web sites directing
Yes and no. First you said ‘send’ sites thru specific interfaces and that is readily done by choosing IP binding when you setup the website. Then you said ‘msn.com’ which is not your website and therefore you are talking about routing incoming sites to specific adapters – NO. If this is the firewall then yes [...]
View Answer
| March 2, 2005 11:21 AM
Development, Networking, Tech support
Yes and no. First you said ‘send’ sites thru specific interfaces and that is readily done by choosing IP binding when you setup the website. Then you said ‘msn.com’ which is not your website and therefore you are talking about routing incoming sites to specific adapters – NO. If this is the firewall then yes [...]
View Answer
| March 2, 2005 11:21 AM
Development, Networking, Tech support
Front-End Reporting Tools for Secure Web Service Application with MS-SQL server-2
It depends how much work want to put in. If you’re using SQL Server 2000 then you might want to look into its Reporting Services which can handle quite a bit. If you really want to save money and you have time to code, check out a product called ActiveReports by Data Dynamics. It’s a [...]
View Answer
| March 2, 2005 11:01 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
It depends how much work want to put in. If you’re using SQL Server 2000 then you might want to look into its Reporting Services which can handle quite a bit. If you really want to save money and you have time to code, check out a product called ActiveReports by Data Dynamics. It’s a [...]
View Answer
| March 2, 2005 11:01 AM
Compliance, CRM, Disaster Recovery, Dreamweaver, E-business, Microsoft Access, Microsoft Office, Microsoft Windows, Policies, Risk management, Security Program Management, Servers, SQL Server
