DSXchange

Hi All, I have a job Sequence , 3 job in batch mode, so i need to set up like that after finishing all my 3 job sucessfully i need to delete all data from one Teradata table. so please tell me what stage should i use or what is possible way to do it? Right now in my company they just made one table ...

DSguru2B wrote:its not a function. just put square brackets" [x,y]" where x is the start point and y is the length.

Actually I tried both way,using Left and Right String Function and also by your methods ,so both working fine.

Thanks.Issue solve.

I_Server_Whale wrote:You can use In.String[1,4] for ABCD and In.String[5,2] for EF.

where i found this function?
reply me thanks.

DSguru2B wrote:Which btw, is also the same as server.

what btw?

Hello All,
can somebody tell me that How to splite string in PX job?
as i know that substring function in server job,but what about PX?
Ex. input - ABCDEF
output - ABCD and EF

Thanks.

Hi All,
I Have same kind of error.
I check i can create/drop table in that DB-Teradata.
and if i create server job its running fine.
so tell me whats solution for this.?
Thanks

Is there is 1:1 or 1:N relationship between file and table?if there is 1:N you cann't perrform look-up.please explain more about this. I have a file with fields field1,field2,field3,field4,field5,field6,field7. and a table with columns col1,col2,col3,col4,col5,col6,col7,col8. i have to perform a loo...

You failed to search the Forums, that's all. I got eight hits on an Exact search for 'could not create operator sync table'. See if any of them help. :wink: Hi I check previouse post .. and i found,the following evn. variable is not defined is really its problem or what? APT_TERA_SYNC_DAEMON_PROG =...

Hi all,
I am loading a Teradata table using Datastage job.
But my job aborted and i got only one fatal error like

main_program: Fatal Error: APT_TeraSync: could not create operator sync table.

so plz tell me where i did mistake?
thanks

thanks narasimha. but actually i am running datastage from other system. and there is no internet excess.sorry for that. Check if this is similar to your first issue http://www.dsxchange.com/viewtopic.php?t=96405&highlight=insufficient+blocks+partition With your second issue with FTP, as per you...

narasimha wrote:Is the row mismatch and the FTP problem related to each other?

no they r both different.right now i update my text using vi editor.copy-paste.but i have lots of file to transfer,so i need help?

Hi all. I m running a job.which load data to Teradata table. But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows. so plz tell me whats reason? Check the director. It seems that the rest of the data got rejected. Look into the Director's log for this job. You will see...

Hi all. I m running a job.which load data to Teradata table. But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows. so plz tell me whats reason? and also i use following FTP script to transfer file to Unix from windows. but it shows me check username/password. @echo off...

Hi Friends.
I have to load one excel file to Teradata DB.
But there is lots of white space in that file -row as well as in column,so need to remove.
and we dont have time to make macros for that.
so plz tell me better way to do it.
ok thanks .