Delete OLD files from Table not having date or timestamp
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...
Hi, In DB2, Is it possible to get the insert date of a record in a table which doesn't have a seperate field for creation date or timestamp. I have a task where I have to delete record older than 1 year from a table, but the files doesn't have creation date field. So, like RRN does DB2 have any...
30 pts.
Why is SSIS xml variable in escaped format?
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...
In SSIS 2005 I use Execute SQL task to execute a proc that returns an xml resultset using these clauses (For XML Auto, Type within a For XML Path, Type). I return that resultset into string variable User::vSelectedClients. When I look at that variable within a breakpoint, I see all the doublequote...
Convert column from Number(9) to varchar2(3) in SQL
What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....
What is the quickest way of achieving a total column datatype change from number(9) to varchar(3)? I have a few million rows in this table and SQL will run forever ....
0 Row affected
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...
Could you please assist with the following? UPDATE dbo.[Elution_Report_Template] SET [Elutriation_Set_SqM] = dbo.[Elution_Report].[Elutriation_Set_SqM], [Elutriation_Pump_SqM] = dbo.[Elution_Report].[Elutriation_Pump_SqM], = dbo.[Elution_Report]., = dbo.[Elution_Report]., =...
Separator Line in ASP.NET Gridview
Hello, I’m relatively new to ASP.NET and SQL, so what I’m asking maybe a simple question for some, but not for me. What I have is a Grid View that I’m trying to populate softball hitting statistics with. In it I’ve stacked statistics yearly statistics on top of career totals at the very...
Hello, I’m relatively new to ASP.NET and SQL, so what I’m asking maybe a simple question for some, but not for me. What I have is a Grid View that I’m trying to populate softball hitting statistics with. In it I’ve stacked statistics yearly statistics on top of career totals at the very...
Using SQL Connect Statement in SQLRPGLE
I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...
I need to use the SQL CONNECT statement within a SQLRPGLE program to connect from one AS400 system to another. I need to get data from one file to another. Does anyone know how to do this? Can it be done within a program. I have no trouble when I do it on an SQL command line... I use CONNECT to...
SQL: comparing rows and give the change
saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be...
saving greetings to everyone! i m receiving a dump data at day 1, inserting all that data into a database. this database has about 30 above tables, each and every table has about 100 above rows. every table has a column name cell id. on 2nd day i again receive the dump which also has to be...
top values and ranking
What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.
What function do i use to give a field a ranking based on it's current sorted position in a query. I do not want to use a running sum on a report - it needs to be in the underlying query as I am going to have to join several together.
about visual basic.net
Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...
Hi I install vb.net ready and make connection ready, but when I try to using SQL statement it is error: my SQL is dim strSQL as string="select * from tblCustome where CustomerID="& intCustomerID the error is it does not no the string &? Please show me the solution how to solve this error! thank my...
I NEED HELP WITH A SQL PROBLEM
I have a SQL statement that reads as follows: select subject1, subject2, subject3, subject4, subject5, subject6 from card_catalog where subject1 like ? This SQL statement works I just do not have the statement in front of me to type it in correctly. Is what my real question is. I have a TEXTBOX...
I have a SQL statement that reads as follows: select subject1, subject2, subject3, subject4, subject5, subject6 from card_catalog where subject1 like ? This SQL statement works I just do not have the statement in front of me to type it in correctly. Is what my real question is. I have a TEXTBOX...
SQL script to disable views after a demo period.
Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...
Hi, I have a sql view that I created for someone on a test basis. I want to create something (stored procedure, trigger, etc) that will delete or disable this view after a 30 day trial period. I prefer to make the view unvisible even to the "sa" administrator so that the view can not be recreated...
Update DateStructure Field through SQL Query
I wanna update a field in the table(which is a Data Structure) through Sql Query.. Can anyone help in this regard>>
I wanna update a field in the table(which is a Data Structure) through Sql Query.. Can anyone help in this regard>>
Crystal Reports Duplicating Records
Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...
Hi, I hope that someone can help me. We are currently replacing a system with a new version and as such we are building a new SQL DB. Although the two DBs store the same information they don't share a common layout. I have created a basic report to see if the record count for a certain select...
SQL/400 Call Level Interface
The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you...
The option set thru the SQLSetConnectionAttr call persists until the next SQLSetConnectAttr call. If I need to set another option, how do I know that the effect of the previously set option is no longer required? Can I set connection attributes after I have connected to the database? Thank you...
Difference between ODBC and JDBC?
I'm writing a java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400...
I'm writing a java application. In short, this application needs to connect to DB2 on an AS/400 for some SQL data. I cannot find a straightforward comparison of ODBC and JDBC. Do any of you know where I can find one? Or, have any of you done java programming with the intent to connect to AS/400...
Access paths no longer valid
Ok, the plot thickens. I'm trying to identify and rebuild LFs that after an abnormal shutdown and normal ipl, are no longer being selected for SQL and QRY. These files are not damaged, but program response has taken a major hit due to these views not being selected. After researdhing one known...
Ok, the plot thickens. I'm trying to identify and rebuild LFs that after an abnormal shutdown and normal ipl, are no longer being selected for SQL and QRY. These files are not damaged, but program response has taken a major hit due to these views not being selected. After researdhing one known...
jsp--param and sql:update
Hello, Could anyone tell me if I need to do something special to use a param value as an sql insert statement in <sql:update>? The param value displays fine if I use <c:out>, but the value doesn't get inserted in a table by an insert statement.
Hello, Could anyone tell me if I need to do something special to use a param value as an sql insert statement in <sql:update>? The param value displays fine if I use <c:out>, but the value doesn't get inserted in a table by an insert statement.
Problem with ++ string operator in VB.NET
command3 = New Data.SqlClient.SqlCommand("UPDATE Products SET Stock=" + numU + " Where ProductName='" + proName + "'", connection3) At the code snippet above, numU is integer and when i execute it in insert at sql server as a double so it throws me an error and says me that its a double and you...
command3 = New Data.SqlClient.SqlCommand("UPDATE Products SET Stock=" + numU + " Where ProductName='" + proName + "'", connection3) At the code snippet above, numU is integer and when i execute it in insert at sql server as a double so it throws me an error and says me that its a double and you...
Delete variable file in SQLRPG
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?
How can I use any variable file in an instruction SQL of DELETE in SQLRPG?
understanding and detecting sql performance situation with abnormal 400 shutdown
Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...
Need help in understanding and detecting situation with logical files built for sql rpgle performance and abnormal shutdown. Our system went down due to ups failure. All of a sudden the rpgle sql program is a resource hog because it is not selecting the lf that was built specifically for...
