Search Results

I tried to execute only the if exist statement to know if it throws error in starting itself.
Example:
if exists(select 1 from sysobjects where name = 'sample_table' and type = 'U')
begin
...

Yes, the DB user has all the access permissions.

Dear Neo,

That's why I have wrote else part, if the table is not found it should create and insert the data from temp table. but, it hasn't worked.
Table data is as below:
22055;20181009;...

Hello Everyone,

Coming again for your help to solve the below error:

In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully)...

Hello Everyone,

Coming again for your help to solve the below error:

In a script, i had created a temp table (Temp_table) and loaded the data in it using bcp command (performed successfully)...

Thank you. Actually the problem is with the file format at end of each line. So, I have added a semicolon delimiter and tried accessing the bcp command to load the data into Sybase.

awk -v d=`date...

Sorry, I didn't understand could you breif the idea you are proposing.

Thanks

Hi All,

I had an issue in executing bcp command to connect to Sybase from Unix script for uploading the data from file to table.

I have a file called vrs_temp.txt (with two columns):
...

Thanks both of you for your response and showing the error in the command which I return.


1. I clarified with sed command.
2. For the output with AWK command what is the difference between OFS...

Hi All,

I have a file with only one column of data (without delimiter). For Ex:

cat temp.txt
22055
21088
93840
30990
50990
50950

I want to insert an additional column with current date...