Want to delete objects of type ‘File’ except ‘source physical file’
I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type ‘*FILE’ and object attribute ‘PF’ but the problem is I don’t want to delete ‘Source physical files’. I just want to delete files except ‘Source physical file’. can anybody suggest how to do that ?
Answer Question
| June 9, 2011 11:07 AM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
I have taken output of DSPOBJD in a database file. Now I want to delete all the objects having type ‘*FILE’ and object attribute ‘PF’ but the problem is I don’t want to delete ‘Source physical files’. I just want to delete files except ‘Source physical file’. can anybody suggest how to do that ?
Answer Question
| June 9, 2011 11:07 AM
AS/400 Database File, AS400 physical file, Database Files, DSPOBJD, Physical Files
Empty reports in TMG2010
I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection…
Answer Question
| June 6, 2011 5:15 AM
Forefront TMG 2010, Report Server, SQL Express, SQL Server Report Server, WAIK for Windows 7, Windows Server 2008 R2
I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection…
Answer Question
| June 6, 2011 5:15 AM
Forefront TMG 2010, Report Server, SQL Express, SQL Server Report Server, WAIK for Windows 7, Windows Server 2008 R2
AS/400 tab text delimited format of physical file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Related to SQL server 2005
When we write store procedure it is encrypt by –with encrypt tag means it will locked it doesn’t show sp so how it will be DECRYPT?
Answer Question
| June 10, 2011 4:39 AM
Decryption, SQL Server 2005, SQL stored procedures, Stored Procedures
When we write store procedure it is encrypt by –with encrypt tag means it will locked it doesn’t show sp so how it will be DECRYPT?
Answer Question
| June 10, 2011 4:39 AM
Decryption, SQL Server 2005, SQL stored procedures, Stored Procedures
Free IT Book: Building Applications in the Cloud
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 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
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 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
Running a query in Oracle 10g
How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?
Answer Question
| June 1, 2011 5:53 AM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
How to rung query in oracle 10 g, if i run query it will be error coming, it will ask connection. can u tell me how connect databse file in sql developer which is install from oracle.com?
Answer Question
| June 1, 2011 5:53 AM
Oracle 10g, Oracle Query, Oracle SQL Developer, SQL Developer
SQL Report Help
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Hi I’m dave and I’m new to the forum, SQL and SSRS. Thanks in advance for your assistance and patience. I have a recall report that produces letters for every patient who needs to return to the office on a certain date based on their recall plan (a plan that determines when they should return [...]
Answer Question
| June 1, 2011 11:35 PM
Reporting, SQL, SQL Reports, SQL Server Reporting Services, SQL Server Reports, SSRS
Data type for output file in DB2 SQL
I am using DB2 SQL on the mainframe – not sure of the version – I want to write out a file and transfer it down to the PC – how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as [...]
Answer Question
| August 12, 2011 8:51 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
I am using DB2 SQL on the mainframe – not sure of the version – I want to write out a file and transfer it down to the PC – how do I specifiy numeric values for dollar values so that when I bring the file into Microsoft Access the numeric fields come in as [...]
Answer Question
| August 12, 2011 8:51 PM
DB2, DB2 SQL, SQL, SQL Database, SQL Server
SQL Server Logins
Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example user = SA password = PassWord123 as it stands “SA” can login with password = password123 how can can i change it so the user cannot login with different case password. I have read about [...]
Answer Question
| January 15, 2012 10:09 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
Hi Currently using SQL server 2000 Is there a way of making SQL server logins use case sensitive passwords. for example user = SA password = PassWord123 as it stands “SA” can login with password = password123 how can can i change it so the user cannot login with different case password. I have read about [...]
Answer Question
| January 15, 2012 10:09 AM
SQL 2000, SQL Logins, SQL Server 2000, SQL Server Password Management, SQL Server Passwords
SQL studio manager installation issue
Hi group, I am installing MS Studio manager 2005 but this will get recomment me to install MSXML 6 ,i installed this but then it recmoment to install Power shell ,i install this too but it recomment to install something new tooo. I installed windows new windows XP 2007SP2. this error occur 1st time. I [...]
Answer Question
| May 24, 2011 2:20 AM
PowerShell, SQL Server, SQL Server Express 2005, SQL Server Management
Hi group, I am installing MS Studio manager 2005 but this will get recomment me to install MSXML 6 ,i installed this but then it recmoment to install Power shell ,i install this too but it recomment to install something new tooo. I installed windows new windows XP 2007SP2. this error occur 1st time. I [...]
Answer Question
| May 24, 2011 2:20 AM
PowerShell, SQL Server, SQL Server Express 2005, SQL Server Management
You Pick: Drupal’s Building Blocks, Scalability Rules, Building Cloud Apps, DTrace
This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal’s Building Blocks Building Applications in the Cloud DTrace To win one of these great resources, answer a question from the [...]
Answer Question
| May 25, 2011 5:22 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal’s Building Blocks Building Applications in the Cloud DTrace To win one of these great resources, answer a question from the [...]
Answer Question
| May 25, 2011 5:22 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Server 2008 restore error
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Answer Question
| March 12, 2012 7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
error message : The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.1600. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
Answer Question
| March 12, 2012 7:33 AM
Restore Database, SQL Server 2008, SQL Server 2008 error messages, SQL Server backup, SQL Server backup and restore
Contest Bounty: Ask/Answer questions this weekend, earn 100 points!
Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of asking/answering is acceptable. Post the links [...]
Answer Question
| May 20, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of asking/answering is acceptable. Post the links [...]
Answer Question
| May 20, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
SQL Update not Working using two files
I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT B.B1N4CD FROM DABCON2/VDA_CS B [...]
Answer Question
| April 6, 2012 3:39 PM
AS/400, AS/400 SQL, SQL, SQL Server, SQL Server Updates
I have attempted to update one file with data from another but I am getting two different errors depending on how I enter my statements. I used information from this site as a reference for these statements but I must be doing something wrong. UPDATE DABCON2/ACTPHY01 A SET A.B1N4CD = (SELECT B.B1N4CD FROM DABCON2/VDA_CS B [...]
Answer Question
| April 6, 2012 3:39 PM
AS/400, AS/400 SQL, SQL, SQL Server, SQL Server Updates
Empty Reports in Forefront TMG SP1
Hello! I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)” but I`ve solved it by re-writing connection string(I`ve [...]
Answer Question
| May 18, 2011 11:48 AM
Forefront TMG, Forefront TMG 2010, SQL Server, Windows Server 2008, Windows Server 2008 R2
Hello! I am running Windows Server 2008 R2 Enterprise and Forefront TMG 2010 adn SQL-Express as local database After upgrading Forefront TMG 2010 to sp1 reports stopped generates. Reports are empty. First problem was “The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)” but I`ve solved it by re-writing connection string(I`ve [...]
Answer Question
| May 18, 2011 11:48 AM
Forefront TMG, Forefront TMG 2010, SQL Server, Windows Server 2008, Windows Server 2008 R2
Free IT Book: Governing Shared Services On-Premise and in the Cloud
This week’s free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: “[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA and service-orientation….[It] steps the readers through the most [...]
Answer Question
| November 30, 2011 4:04 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
This week’s free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: “[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA and service-orientation….[It] steps the readers through the most [...]
Answer Question
| November 30, 2011 4:04 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
How to make the connection in SQL 2000 with Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
SQL9010 is: RUNSQLSTM command failed.
SQL9010 is: RUNSQLSTM command failed.
Answer Question
| May 17, 2011 6:25 AM
RUNSQLSTM, SQL error messages, SQL Server
SQL9010 is: RUNSQLSTM command failed.
Answer Question
| May 17, 2011 6:25 AM
RUNSQLSTM, SQL error messages, SQL Server
SQL Oracle for rolling the period return
Hi , i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query . return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]
Answer Question
| May 16, 2011 5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Hi , i had requirement such that .. if i enter a period , it should return 5 other periods based on that in oracle sql query . return of period is done as below .. for Jan 2011 it should return march2010,june2010,sep2010,dec2010,jan2011 for feb it should return march2010,june2010,sep2010,dec2010,feb2011 for march it should return march2010,june2010,sep2010,dec2010,march2011 for April [...]
Answer Question
| May 16, 2011 5:56 PM
Oracle SQL, Oracle SQL Developer, Oracle SQL Pagination, SQL Database
Running a script against local SQL servers
Hi guys i am trying to run a script against local servers stored on a txt file i have already used osql to list the output to a text file. but after this probs
Answer Question
| May 22, 2011 7:59 PM
SQL, SQL Scripting, SQL scripts, SQL Server, Windows XP
Hi guys i am trying to run a script against local servers stored on a txt file i have already used osql to list the output to a text file. but after this probs
Answer Question
| May 22, 2011 7:59 PM
SQL, SQL Scripting, SQL scripts, SQL Server, Windows XP
