AS/400 tab text delimited format of physical file
Can you also state which ‘utility tool’ you are using for the download. We’ll all assume that you are refering to Client Acess transfers, but there are others.
View Answer
| June 10, 2011 9:30 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Can you also state which ‘utility tool’ you are using for the download. We’ll all assume that you are refering to Client Acess transfers, but there are others.
View Answer
| June 10, 2011 9:30 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Embedded SQL using SUM or some other method to total up qty and display 1 unique record
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
select ser#, <b>count(*) </b> as count, <b>sum(qty)</b> as total from file <b>group by </b>ser#
View Answer
| June 9, 2011 1:44 PM
Embedded SQL, SQL, SQL Select, SQL Select statement problem, SQLRPG
Free IT Book: The Data Warehouse Mentor
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
twitted http://twitter.com/#!/batye1
View Answer
| June 7, 2011 6:29 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Want to delete objects of type ‘File’ except ‘source physical file’
A source file should have an attribute of PF-SRC So first you would need to delete LF objects, then PF objects. If there is on a single library or two, the easist way without doing any coding is using a User defined PDM option. If you do WRKOBJPPDM xxxx where xxxx is your library name. [...]
View Answer
| June 7, 2011 12:35 PM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
A source file should have an attribute of PF-SRC So first you would need to delete LF objects, then PF objects. If there is on a single library or two, the easist way without doing any coding is using a User defined PDM option. If you do WRKOBJPPDM xxxx where xxxx is your library name. [...]
View Answer
| June 7, 2011 12:35 PM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
Free IT Book: Building Applications in the Cloud
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
just twited http://twitter.com/#!/batye1 batye1 ALEXANDER STEPHENS Ask & answer #tech questions with other #ITpros at @ITKE: bit.ly/986ff0
View Answer
| June 2, 2011 3:18 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Report Help
Like I tell everyone who has basic understanding of reports use the free program Expressor and have them teach you during a free webinar how to use the program. I am in love with this program. It is basically DreamWeaver for Reports. <a href=”http://www.expressor-software.com/”>Expressor
View Answer
| June 1, 2011 9:39 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Like I tell everyone who has basic understanding of reports use the free program Expressor and have them teach you during a free webinar how to use the program. I am in love with this program. It is basically DreamWeaver for Reports. <a href=”http://www.expressor-software.com/”>Expressor
View Answer
| June 1, 2011 9:39 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Data type for output file in DB2 SQL
There is no such thing as “numeric” in a file. A file, whether on a mainframe or on a PC, is just a collection of bytes. Within certain products ( e.g. DB2, EXCEL ) one can tell the product that a specified field is numeric. But if you save an EXCEL spreadsheet to a file [...]
View Answer
| June 1, 2011 4:38 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
There is no such thing as “numeric” in a file. A file, whether on a mainframe or on a PC, is just a collection of bytes. Within certain products ( e.g. DB2, EXCEL ) one can tell the product that a specified field is numeric. But if you save an EXCEL spreadsheet to a file [...]
View Answer
| June 1, 2011 4:38 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
Running a query in Oracle 10g
In Sql Developer, there is a “Connections” tab on the left hand side. You need to create a new connection there by right-clicking on “Connections”, selecting “New Connection” and filling in the server name/address, port, and database SID. You can also use your TNS configuration and avoid entering the above details which are already included [...]
View Answer
| June 1, 2011 2:59 PM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
In Sql Developer, there is a “Connections” tab on the left hand side. You need to create a new connection there by right-clicking on “Connections”, selecting “New Connection” and filling in the server name/address, port, and database SID. You can also use your TNS configuration and avoid entering the above details which are already included [...]
View Answer
| June 1, 2011 2:59 PM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
Free IT Book: Governing Shared Services On-Premise and in the Cloud
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Spam removed.
View Answer
| May 23, 2011 1:26 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
SQL Server 2008 restore error
Are you asking a questions? Seems like you error message did explain the problem and the solution.
View Answer
| May 23, 2011 8:13 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
Are you asking a questions? Seems like you error message did explain the problem and the solution.
View Answer
| May 23, 2011 8:13 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
SSIS 2008 R2 performance and Windows Server 2008 R2 with a clustered SQL instance is slower than when connecting to a non-clustered instance?
If SSIS and the SQL Instance are running on the same physical server then the connection should not be going out over the network. If they are on different nodes then the connection will go over the network. By default connections made that don’t leave the server are made over the shared memory protocol driver. [...]
View Answer
| May 22, 2011 7:37 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2
If SSIS and the SQL Instance are running on the same physical server then the connection should not be going out over the network. If they are on different nodes then the connection will go over the network. By default connections made that don’t leave the server are made over the shared memory protocol driver. [...]
View Answer
| May 22, 2011 7:37 AM
Business Information Warehouse, SQL Server, SQL Server 2008 R2, SQL Server 2008 R2 Performance Monitoring, SQL Server Performance Monitoring, SSIS, Windows Server 2008 R2
SQL Update not Working using two files
I think you’ve figured out that the ACTPHY01 table doesn’t accept nulls for B1N4CD field, and that is the reason why you tried to use “coalesce” function in the second command, is that correct? I think you are using COALESCE in wrong way, because COALESCE uses 2 parameters, the first one is for the field [...]
View Answer
| May 19, 2011 4:12 PM
AS/400, AS/400 SQL, SQL, SQL Server, SQL Server Updates
I think you’ve figured out that the ACTPHY01 table doesn’t accept nulls for B1N4CD field, and that is the reason why you tried to use “coalesce” function in the second command, is that correct? I think you are using COALESCE in wrong way, because COALESCE uses 2 parameters, the first one is for the field [...]
View Answer
| May 19, 2011 4:12 PM
AS/400, AS/400 SQL, SQL, SQL Server, SQL Server Updates
ssrs interview questions and answers
ssrs interview questions and answers <a href=”http://www.sql-server-business-intelligence.com/sql-server/ssrs/ssrs-interview-questions-and-answers-pdf-download”>ssrs interview questions and answers ssis interview questions and answers <a href=”http://www.sql-server-business-intelligence.com/sql-server/ssIs/ssIs-interview-questions-and-answers-pdf-download”>ssis interview questions and answers
View Answer
| May 19, 2011 5:36 AM
Careers, SSRS, SSRS Careers
ssrs interview questions and answers <a href=”http://www.sql-server-business-intelligence.com/sql-server/ssrs/ssrs-interview-questions-and-answers-pdf-download”>ssrs interview questions and answers ssis interview questions and answers <a href=”http://www.sql-server-business-intelligence.com/sql-server/ssIs/ssIs-interview-questions-and-answers-pdf-download”>ssis interview questions and answers
View Answer
| May 19, 2011 5:36 AM
Careers, SSRS, SSRS Careers
Completed IT Knowledge Exchange Profile? Earn points!
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
http://itknowledgeexchange.techtarget.com/profile/Batye/
View Answer
| May 18, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Oracle for rolling the period return
Depending on the database version, you could use an ugly query like this: <pre>WITH temp AS (SELECT entered,ADD_MONTHS(entered,DECODE(MOD(TO_CHAR(entered,’mm’),3),0,0,3-MOD(TO_CHAR(entered,’mm’),3))) next FROM (SELECT TO_DATE(’01′||’&per’,'ddmonyyyy’) entered FROM dual) t) SELECT TO_CHAR(ADD_MONTHS(next,-12),’monyyyy’) period,1 FROM temp UNION SELECT TO_CHAR(add_months(next,-9),’monyyyy’),2 FROM temp UNION SELECT TO_CHAR(add_months(next,-6),’monyyyy’),3 FROM temp UNION SELECT TO_CHAR(add_months(next,-3),’monyyyy’),4 FROM temp UNION SELECT TO_CHAR(entered,’monyyyy’),5 FROM temp ORDER BY 2;</pre> Maybe [...]
View Answer
| May 16, 2011 4:59 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Depending on the database version, you could use an ugly query like this: <pre>WITH temp AS (SELECT entered,ADD_MONTHS(entered,DECODE(MOD(TO_CHAR(entered,’mm’),3),0,0,3-MOD(TO_CHAR(entered,’mm’),3))) next FROM (SELECT TO_DATE(’01′||’&per’,'ddmonyyyy’) entered FROM dual) t) SELECT TO_CHAR(ADD_MONTHS(next,-12),’monyyyy’) period,1 FROM temp UNION SELECT TO_CHAR(add_months(next,-9),’monyyyy’),2 FROM temp UNION SELECT TO_CHAR(add_months(next,-6),’monyyyy’),3 FROM temp UNION SELECT TO_CHAR(add_months(next,-3),’monyyyy’),4 FROM temp UNION SELECT TO_CHAR(entered,’monyyyy’),5 FROM temp ORDER BY 2;</pre> Maybe [...]
View Answer
| May 16, 2011 4:59 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
How to make the connection in SQL 2000 with Visual Basic 6
<a href=”http://www.vbforums.com/archive/index.php/t-178076.html”>http://www.vbforums.com/archive/index.php/t-178076.html</a> Substitute your own parameters where applicable. ADO is fairly straightforward to work with. If you have any issues, post back and we’ll try to take care of them!
View Answer
| May 16, 2011 3:36 PM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
<a href=”http://www.vbforums.com/archive/index.php/t-178076.html”>http://www.vbforums.com/archive/index.php/t-178076.html</a> Substitute your own parameters where applicable. ADO is fairly straightforward to work with. If you have any issues, post back and we’ll try to take care of them!
View Answer
| May 16, 2011 3:36 PM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
SQL9010 is: RUNSQLSTM command failed.
The RUNSQLSTM produces a print file output. Look at the bottom of the report to get the reason for the failure. You have not given us enough information. If you still hav a problem, Post the source for the RUNSQLSTM and then we can maybe help you
View Answer
| May 15, 2011 8:53 PM
RUNSQLSTM, SQL error messages, SQL Server
The RUNSQLSTM produces a print file output. Look at the bottom of the report to get the reason for the failure. You have not given us enough information. If you still hav a problem, Post the source for the RUNSQLSTM and then we can maybe help you
View Answer
| May 15, 2011 8:53 PM
RUNSQLSTM, SQL error messages, SQL Server
SQL processor license
You will need to purchase 2 processor licenses as you need to license it based on the number of processors that are located in the server running SQL. <a href=”http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx#processor”>
View Answer
| May 13, 2011 5:36 PM
Processor Licence, SQL Server 2008, SQL Server licensing
You will need to purchase 2 processor licenses as you need to license it based on the number of processors that are located in the server running SQL. <a href=”http://www.microsoft.com/sqlserver/2005/en/us/licensing.aspx#processor”>
View Answer
| May 13, 2011 5:36 PM
Processor Licence, SQL Server 2008, SQL Server licensing
Free IT Book: The RAILS 3 Way
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Don’t know, link won’t open
View Answer
| May 12, 2011 5:52 AM
AS/400, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields. I may have [...]
View Answer
| May 10, 2011 6:29 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
I have not been able to find any good examples of what I am trying to do with the create view. I did combine all of the fields from the header and the detail into their own new file to reference as an external data structure. This shows all of the fields. I may have [...]
View Answer
| May 10, 2011 6:29 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
