Search results for query: *

Hi there, I have a very basic problem, I have a Teradata Database to which I connect and select the inofrmation I need, I was trying to use MS Access to connect to the database and link the tables, I am getting this crypted error Reserved error <Item>; there is no message for this error...

Hi, Is it possible to do the following on a UNIX server. Can we point a particular directory (e.g $HOME/incoming_data/) in UNIX file system so that points to a particular directory ( e.g Z:/documents/outgoing_data ) on a SHARED windows server. The crux of this is , say there has been a new...

Hi There, I have a functional UNIX script that handles the ftp of files between two UNIX servers, Now I want to change it a bit so that It can handle FTP from a NT server into a UNIX Server, This script should run on the UNIX server, so when I do ftp xx.xx.xxx.xx ( ip address of the NT...

Hi All, This might be pretty basic, Say like I have a field type VARCHAR(10), Couple of records were just numbers and some records have Characters in them, How I can write a simple query to get only those records which have characters in them ( Not the ones with pure numbers ) Thank You all...

All, I have an issue, Any input from your experience is highly regarded. I have a .csv file ( in which some data inside the fields is also seperated by a comma ), I need to get a pipedelimited falt file, So If I am doing a , It's substituting all comma "," with a delimter "|" BEGIN{} { if(NR...

As a part of my task I have to ftp a file from one unix server onto the another UNIX server, I was able to do it inte ractively, I jsut thought of coming up with a script, after some dragging the feet I wrote this script, But when I run this, it kind of just hangs up and does nothing, I...

Hi All, I am a novice to Perl Programming. I would greatly appreciate if somebody can just lead me some way on How I could handle this problem. As of Now I recieve Excel sheet data which is updated monthly. I need to automate the process of extracting the data in Excel sheets and placing...

Hi, I have a situation where I have to grep for the Pattern, and notjust one keyword or one line. Anyway I can do that, Your help is appreciated, Thanks

Hi All, This maybe a Basic Question. I am using WINSQL as a client to query a Redbrcik Database. Somehow when I use the following command. truncate table A it gives me a syntax error I was able to do it with comman delete from A I just want to know what is the problem with the syntax...

Hi all, I have a .dat file on UNIX which is pretty huge, I just need to import it onto my localmachine(which is on NT). I need some guidance in using FTP commands. Thanking You, RK

Hi, I have a problem at hand. Any help is highly appreciated. I have a table with 16000 rows in which one of the column data type is &quot;long&quot; type. I am unable to find the length of the characters stored in that particular column. So I used an ETL tool and extracted the data...

Hi, I have a table with 16000 rows in which one of the column data type is &quot;long&quot; type. I am unable to find the length of the characters stored in that particular column. Also, When I tried to extract them , the data gets truncated and returns only a single char. So I used...

Hi all, I have a situation where I need to extract all the columns except for one. What is the best way to do it Any input is appreciated Cheers and warm regards R

Hi, I am having the following problem I have the following query with an inline view, Select C.CONT_INTERNAL_ID||C.CONT_NUM, C.CTAWDTYP_CD, TXT_TBC_VAL from CONT C, (Select T.TXT_TBC_CDE, TXT_TBC_VAL from TTBC T WHERE NUM_TBH_ID = 501) X WHERE C.CTAWDTYP_CD = X.TXT_TBC_CDE (+) I tried...