|
Hi we have been running the DTS package for Direct Deposits, for a while now and suddenly is very slow and data is not updated on applications for users.We get data from ftp files to the tables.
Thank you
|
|
|
|
|
This is more of a comment than a question! Not a lot to go on is there? To help we need to know a bit about the dts package, the tables etc etc.
A guess? Try checking your error messages fromt the dts steps.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I have a column that contains varchar values, the structure that the values are built is always the same, first six characters is a string prefix, anything after the prefix must be int or it is invalid.
What I want to do is subtring the column starting at character 7 for the rest of the value, but how do I validate if that value returned by the substring is int.
something like if value is int, is there a way that I can do this?
So lets say the column contains the following values:
abcdef123321
abcdef78998745
abcdef4568547
abcdef123548/
it should only return the first 3 rows because the fourth row is invalid because of the "/" at the end
Thanks in advance
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
You can use the sql ISNUMERIC
declare @variable varchar(100)<br />
set @variable = 'abcdef78998745'<br />
select isnumeric(substring(@variable,7,datalength(@variable)-6))<br />
--returns 1<br />
<br />
set @variable = 'abcdef4568547'<br />
select isnumeric(substring(@variable,7,datalength(@variable)-6))<br />
--returns 1<br />
set @variable = 'abcdef123548/'<br />
select isnumeric(substring(@variable,7,datalength(@variable)-6))<br />
--returns 0 as not numeric
Hope this helps
Bob
Ashfield Consultants Ltd
|
|
|
|
|
I think this will do the trick, thanks a million.
No matter how long he who laughs last laughs, he who laughs first has a head start!
|
|
|
|
|
No problem
Bob
Ashfield Consultants Ltd
|
|
|
|
|
here it is
select *,substring(value,7,len(value)) as intValue from myTable<br />
where charindex('/',value) =0
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
|
|
|
|
|
Dear Friends,
I m working on VC++ application using Oracle with ODatabase.
I m able to execute the query "SELECT SYSDATE FROM DUAL"...
but how to take this data in a Date variable in my application...
Can anybody help me out???
Megha
|
|
|
|
|
I've an MFC application which uses SQL connection using Namedpipes. I'm getting crash in the application log as follows.
Fault address: 7331293E 01:0000193E C:\bin\DBNMPNTW.DLL
Call stack:
Address Frame
7331293E 013D68DC ConnectionTransact+1AE
I'm not getting any clue of why the crash is happening at this point. After opening for a long time, it just crashes at this point !!!!!
Appreciate if some body can shed a light on the reason, what all could be the reason.
Arun K Ramachandran
|
|
|
|
|
I am trying to understand the impact of network traffic on data performance in my environment.
For example, if I am inserting 2 million rows into a database then how can I determine how much time is spent on network traffic? And how can I determine the savings of performing a batch update?
|
|
|
|
|
I don't know what to tell you about HOW to measure the network overhead as I am not a network professional, I imagine you'd have to inspect the packets going over the wire. But I CAN tell you that batches get exponentially faster than RBAR (row by agonizing row) transfers the more data you're working with. Imagine what the network overhead is for one round trip to your database. When you perform batches that overhead becomes a constant. But when you perform RBAR operations over the network that overhead is added for EVERY row. If you are working with that much data then it shouldn't even be a question of wither or not to batch update. Use BULK INSERT or SSIS/DTS but don't do it RBAR.
|
|
|
|
|
I have a stored procedure in oracle that looks like this:
<br />
PROCEDURE validate_master_account_id (v_master_account_id IN NUMBER, v_is_valid OUT NUMBER); <br />
And a procedure that looks like this:
<br />
public static bool TestProcedure()<br />
{<br />
string procedureName = "SMT.CPR_MASTER_ACCOUNT_PKG.validate_master_account_id";<br />
using (OracleConnection connection = new OracleConnection(AppSettings.ConnectionString))<br />
{<br />
connection.Open();<br />
<br />
using (OracleCommand command = new OracleCommand(procedureName, connection))<br />
{<br />
command.Parameters.Add("v_master_account_id", OracleType.Number).Value = 16793;<br />
command.Parameters.Add("v_is_valid", OracleType.Number).Direction = ParameterDirection.Output;<br />
<br />
command.ExecuteNonQuery();<br />
bool result = ((int) command.Parameters["v_is_valid"].Value) == 1;<br />
return result;<br />
}<br />
}<br />
}<br />
I get an error message that says "ORA-01036: illegal variable name/number" and I can't figure out why?
Thanks in advance.
|
|
|
|
|
|
Remember the error is coming from Oracle, not from C#.
Set the commandtype to stored procedure.
|
|
|
|
|
Yeah, that did it, thank you.
|
|
|
|
|
Hi All,
When I try to enter a command in any of the modules in a MS Access database, the command turns RED. It also constantly moves the cursorn to the left leaving NO spaces.
Trying to enter a command such as DoCmd. will open the popup window and then immediately close, and the DoCmd. turns RED.
Please tell me what is causing this. The database functions properly, but entering new code is a real pain.
Thanks
Gene
|
|
|
|
|
i have installed oracle9i..i want to know the host string to acces it through sqlplus..please provide me information about where can i found the host name in my computer...i caanot find it in tnsnames.ora file..could anyone give me guidance to find it
modified on Friday, May 23, 2008 4:25 AM
|
|
|
|
|
Hi everyone, Does sql server 2005 different with sql server 2008 or no?
Thanks
|
|
|
|
|
|
Yes.
^
Bob
Ashfield Consultants Ltd
|
|
|
|
|
how to insert username and password in table(sql server 2005)
with case sensitive.
so I can check small(abc...) and capital(ABC...) letters also while logged in.
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Hi,
Just use UPPER & LOWER method during insert command in sql...
|
|
|
|
|
that is fine but it will be static in either small or block letters.
I want in, whatever user enter in small or block letter.
should not be changed internally.
thanks to give me response.
You get the best out of others when you give the best of yourself.
|
|
|
|
|
Just insert teh values as suppplied, then when you are looking for them use
select *<br />
from table<br />
where convert(varbinary,username) = convert(varbinary,@inputvalue)
Using varbinary effectively makes the select case sensitive
Bob
Ashfield Consultants Ltd
|
|
|
|
|
thanks a lot for your kind help.
it's also working fine.......
thanks
You get the best out of others when you give the best of yourself.
|
|
|
|