Pb with notes database
First of all why dont you upgrade to ODS51 ???? Add the following parameter to the server’s Notes.ini http://www-10.lotus.com/ldd/dominowiki.nsf/dx/create_r85_databases Second of all ,,, what is the problem you are sufrreing from ??
View Answer
| November 22, 2009 8:34 AM
Lotus Notes mail database, ODS Index
First of all why dont you upgrade to ODS51 ???? Add the following parameter to the server’s Notes.ini http://www-10.lotus.com/ldd/dominowiki.nsf/dx/create_r85_databases Second of all ,,, what is the problem you are sufrreing from ??
View Answer
| November 22, 2009 8:34 AM
Lotus Notes mail database, ODS Index
Is there dashboard/data mining software which is geared for a small business?
This might help if you are a developer. It easily graphs data and supports drill down. It’s totally free and totally customizable if you have Excel. <a href=”http://itknowledgeexchange.techtarget.com/beyond-excel/”>Beyond Excel</a>
View Answer
| November 19, 2009 2:43 AM
Dashboard software, Data Mining, Data mining/analysis
This might help if you are a developer. It easily graphs data and supports drill down. It’s totally free and totally customizable if you have Excel. <a href=”http://itknowledgeexchange.techtarget.com/beyond-excel/”>Beyond Excel</a>
View Answer
| November 19, 2009 2:43 AM
Dashboard software, Data Mining, Data mining/analysis
Crystal reports formula
In Field Explorer, select Running Total Field and click the New button to display the Create Running Total Field box Type in a name From the available Tables and Field list box, select the field to summarise From the Type of Summary drop down list, select the type of summary you want In the Evaluation [...]
View Answer
| November 18, 2009 4:30 PM
Crystal Reports, Crystal Reports formulas
In Field Explorer, select Running Total Field and click the New button to display the Create Running Total Field box Type in a name From the available Tables and Field list box, select the field to summarise From the Type of Summary drop down list, select the type of summary you want In the Evaluation [...]
View Answer
| November 18, 2009 4:30 PM
Crystal Reports, Crystal Reports formulas
DECFLOAT – Internal Format
Hello, I am not sure what you mean by “visual format.” I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ———+———+———+———+———+———+—– DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 INSERT INTO [...]
View Answer
| November 17, 2009 6:42 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
Hello, I am not sure what you mean by “visual format.” I will take a guess that you want a floating point number to be returned to your application as a decimal number. Use the DECIMAL function. For example: CREATE TABLE TTEST (F_COL FLOAT); ———+———+———+———+———+———+—– DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0 INSERT INTO [...]
View Answer
| November 17, 2009 6:42 PM
DB2, DB2 9, DB2 administration, DECFLOAT, z/OS
“map drive” IFS
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]
View Answer
| November 14, 2009 12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support
So if I understand correctly… - You have created “shares” using iSeries Navigator? (i.e. a share named “root” for the / directory, a share named “test” for /home/jdoe/test, and so on) - And using “net use X: QS6555A8Aroot” or “net use Z: QS6555A8Atest” in a DOS box on a client PC doesn’t work? Very strange [...]
View Answer
| November 14, 2009 12:44 PM
390, Access, AS/400, Backup & recovery, Data analysis, Database, DB2, DB2 Universal Database, Desktops, Development, Hardware, IBM, Mainframe, Management, Microsoft Office, Microsoft Windows, OS, RPG, Security, Servers, SQL Server, Storage, Tech support
Crystal Reports X
I have to do somthing similar, what I have done is Create a report with just the one field in it Group by the field so that all records of the same value are together Add a count of records per group in the group header Use a group selection to show groups where the [...]
View Answer
| November 13, 2009 5:24 PM
Crystal Reports formulas, Crystal Reports X
I have to do somthing similar, what I have done is Create a report with just the one field in it Group by the field so that all records of the same value are together Add a count of records per group in the group header Use a group selection to show groups where the [...]
View Answer
| November 13, 2009 5:24 PM
Crystal Reports formulas, Crystal Reports X
SUPRESSING THE GROUP HEADER IN CRYSTAL REPORTS
Why do you have a repeating header? Maybe I am not following, but it sounds like the identical message will repeat on every page, so why not just use page header. If I have totally missed the point (and I feel I must be) then in the supress record for the page header put <pre> [...]
View Answer
| November 11, 2009 6:11 PM
Crystal Reports, Crystal Reports Formatting
Why do you have a repeating header? Maybe I am not following, but it sounds like the identical message will repeat on every page, so why not just use page header. If I have totally missed the point (and I feel I must be) then in the supress record for the page header put <pre> [...]
View Answer
| November 11, 2009 6:11 PM
Crystal Reports, Crystal Reports Formatting
Coding to prevent table overflows withing programs
We used that method back in the early seventies when memory was maxed out at 16k total. Instead of writing to an array (or table) you write to a file. The same exact information in the record as your table would have had. The index becomes the record number! There are far too many different [...]
View Answer
| November 9, 2009 2:56 PM
ABEND, Buffer overflow, COBOL, Easytrieve
We used that method back in the early seventies when memory was maxed out at 16k total. Instead of writing to an array (or table) you write to a file. The same exact information in the record as your table would have had. The index becomes the record number! There are far too many different [...]
View Answer
| November 9, 2009 2:56 PM
ABEND, Buffer overflow, COBOL, Easytrieve
The request could not be submitted for background processing
I am running a CrystalReport 10 report thru ODBC to MS Sql 2000 db. There are Many subreports that are not running until I manually RESET teh SQL Query of Each SubQuery. IS there a Global Update for all subquery within a report?
View Answer
| November 5, 2009 9:19 PM
Crystal Reports 10, Visual Studio 2005
I am running a CrystalReport 10 report thru ODBC to MS Sql 2000 db. There are Many subreports that are not running until I manually RESET teh SQL Query of Each SubQuery. IS there a Global Update for all subquery within a report?
View Answer
| November 5, 2009 9:19 PM
Crystal Reports 10, Visual Studio 2005
Record Count Crystal Reports 2008
Lets say you have these 2 tables: CLIENT table with the columns ID, NAME, etc and CLIENT_ORDERS table with ID, ORD_ID, etc You want CLIENT.NAME, count of orders. something like this should work: SELECT C.NAME , COUNT(CO.ORD_ID) FROM CLIENT C , CLIENT_ORDERS CO WHERE C.ID = CO.ID GROUP BY C.NAME;
View Answer
| November 5, 2009 6:45 PM
Crystal Reports, Crystal Reports 2008
Lets say you have these 2 tables: CLIENT table with the columns ID, NAME, etc and CLIENT_ORDERS table with ID, ORD_ID, etc You want CLIENT.NAME, count of orders. something like this should work: SELECT C.NAME , COUNT(CO.ORD_ID) FROM CLIENT C , CLIENT_ORDERS CO WHERE C.ID = CO.ID GROUP BY C.NAME;
View Answer
| November 5, 2009 6:45 PM
Crystal Reports, Crystal Reports 2008
db2/400
Try google Webquery, i series, console. Phil
View Answer
| November 4, 2009 2:54 AM
AS/400 simulator, DB2, DB2/400
Try google Webquery, i series, console. Phil
View Answer
| November 4, 2009 2:54 AM
AS/400 simulator, DB2, DB2/400
DB2 UDB for iSeries: Using CPYTOIMPF to trim blanks
We recently got this suggestion from a reader: “You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we’re running OS/400 V5R2.” – Michelle ===================================================== If the field being transferred is a CHAR field, then trailing spaces is correct and they should not be truncated. If the field is VARCHAR, then [...]
View Answer
| November 1, 2009 9:19 AM
AS/400, Database, DB2, Oracle
We recently got this suggestion from a reader: “You could try explicitly specifying: RCDDLM(*CRLF) in your CpyToImpF command. It works for me we’re running OS/400 V5R2.” – Michelle ===================================================== If the field being transferred is a CHAR field, then trailing spaces is correct and they should not be truncated. If the field is VARCHAR, then [...]
View Answer
| November 1, 2009 9:19 AM
AS/400, Database, DB2, Oracle
CPYTOPCD filename length limitation
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
The limit of up to 8 chars and up to 3 chars extension applies to all folders and documents in QDLS. This is the only area of the IFS that the CPYTOPCD command will access. You can use COPYTOSTMF to copy a database file to other areas of the IFS as an ASCII text file, [...]
View Answer
| October 31, 2009 9:54 AM
AS/400, Database, DB2, Development, Oracle, Platform Issues
Procedure Pointer
Indicators - <pre> D IndPtr s * Inz(%Addr(*In)) D Indicators s 1 Dim(99) Based(IndPtr) </pre> and if I want to set the indicators say In50 to In54, i would use <pre> %Subarr(Indicators:50:5) = ’10101′; </pre>
View Answer
| October 30, 2009 3:40 PM
AS/400, AS/400 Pointers, AS/400 Procedure Pointer, DB2
Indicators - <pre> D IndPtr s * Inz(%Addr(*In)) D Indicators s 1 Dim(99) Based(IndPtr) </pre> and if I want to set the indicators say In50 to In54, i would use <pre> %Subarr(Indicators:50:5) = ’10101′; </pre>
View Answer
| October 30, 2009 3:40 PM
AS/400, AS/400 Pointers, AS/400 Procedure Pointer, DB2
Workstation ID/IP Address
When you configure their sessions select “Specify workstation ID” then enter the device their device description in the field below. If they need to configure a second configuration if you want them to be able to open a second session and so on. Sound like a make work project to me though… Voodoo ========================================================= You [...]
View Answer
| October 30, 2009 2:17 AM
iSeries Access for Windows, System administration, work management
When you configure their sessions select “Specify workstation ID” then enter the device their device description in the field below. If they need to configure a second configuration if you want them to be able to open a second session and so on. Sound like a make work project to me though… Voodoo ========================================================= You [...]
View Answer
| October 30, 2009 2:17 AM
iSeries Access for Windows, System administration, work management
External DB2 Database link/trigger
Are you asking how to do this on the i5 or is there some other question i’m not seeing? —– Appearantly part of my question disappeared somehow. I wanted to know if it is possible to connect from the i5 to an Oracle database and whether it is possible to have triggers on that external [...]
View Answer
| October 29, 2009 5:27 AM
AS/400 database, DB2, DB2/400, i5/OS, V5R4
Are you asking how to do this on the i5 or is there some other question i’m not seeing? —– Appearantly part of my question disappeared somehow. I wanted to know if it is possible to connect from the i5 to an Oracle database and whether it is possible to have triggers on that external [...]
View Answer
| October 29, 2009 5:27 AM
AS/400 database, DB2, DB2/400, i5/OS, V5R4
How To Print A Hardware Configuration List?
Are you after what is commonly known as a rack configuration ? If so, I use the ‘strsst’ command (to which you’ll need a signon), option 1 to start a service tool and then option 7 for the hardware service manager. From here you can press F6 to print the configuration (look for QPCSMPRT on [...]
View Answer
| October 25, 2009 12:12 PM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Are you after what is commonly known as a rack configuration ? If so, I use the ‘strsst’ command (to which you’ll need a signon), option 1 to start a service tool and then option 7 for the hardware service manager. From here you can press F6 to print the configuration (look for QPCSMPRT on [...]
View Answer
| October 25, 2009 12:12 PM
Backup & recovery, Hardware, i5, IBM, IBM/Tivoli, Installation, Integration/Connectivity, iSeries, Logical partitions, OS/400, PC/Windows Connectivity, Performance/Tuning, Printing, PTFs, Security, Server consolidation, System monitoring, tips and tricks, Tools
Restoring a dtaq in iseries.
you can save the object itself, the data queue, but not what is in it.. ===================================================== Since you don’t tell us anything about your environment, it’s hard to say. But I can suggest looking at the QDTA() parameter of SAVOBJ if you’re at V5R4 or later. Tom
View Answer
| October 25, 2009 10:44 AM
AS/400, Database Management Systems, DataCenter, DB2, Development, Hardware
you can save the object itself, the data queue, but not what is in it.. ===================================================== Since you don’t tell us anything about your environment, it’s hard to say. But I can suggest looking at the QDTA() parameter of SAVOBJ if you’re at V5R4 or later. Tom
View Answer
| October 25, 2009 10:44 AM
AS/400, Database Management Systems, DataCenter, DB2, Development, Hardware
Conversion of SQL Server 2000 to iSeries DB2 V6R1
See if this <a href=”http://www-03.ibm.com/servers/enable/site/db2/downloads/sqlserver.pdf”>DB2 for i5/OS porting guide (SQL Server) .PDF</a> helps. It might raise questions — ask if help is needed. Tom
View Answer
| October 24, 2009 2:28 AM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
See if this <a href=”http://www-03.ibm.com/servers/enable/site/db2/downloads/sqlserver.pdf”>DB2 for i5/OS porting guide (SQL Server) .PDF</a> helps. It might raise questions — ask if help is needed. Tom
View Answer
| October 24, 2009 2:28 AM
DB2, iSeries DB2, SQL Server 2000, SQL Server to iSeries Database, V6R1
CPIB687 conflicting announcement for domain
My personal opinion… Your AS/400 shouldn’t be a master browser. CPU and any other system resources are too expensive to put them to work doing this. Use a far cheaper PC and its memory, its CPU, its network adapter, etc., for this kind of work. ====================================================== The most common setting that I’ve seen that is [...]
View Answer
| October 23, 2009 10:07 PM
i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity
My personal opinion… Your AS/400 shouldn’t be a master browser. CPU and any other system resources are too expensive to put them to work doing this. Use a far cheaper PC and its memory, its CPU, its network adapter, etc., for this kind of work. ====================================================== The most common setting that I’ve seen that is [...]
View Answer
| October 23, 2009 10:07 PM
i5, Integration/Connectivity, iSeries, OS/400, PC/Windows Connectivity
