Hi, I have the below proc sql query where c_accnt table has columns present in attached excel(under updt_col_nm variable).where there are 5columns for c_accnt table.and 1 column each for remaining table.i have to do the same process of updating table in a efficient way. Which should be a dynamic way to do it.can we do this in single query?I have 20 table and their corresponding columns. Pls note: "Updt_col_nm"(varaible name in attached excel) is derived from "thr_pt_acct_nr_col_nm". I have used below query to update single table- Proc sql, Connect to teradata as tera(server="&eiwdb" authdomain="&segkc" mode=teradata); Execute( Update hst From libname.c_accnt hst, Libname.tb_rflkup lkp Set C_account_no=substr(lkp.new_thr_pt_acct_nr,7,23), C_account_no_cl=substr(lkp.new_thr_pt_acct_nr,7,23), C_company_id=substr(lkp.new_thr_pt_acct_nr,1,3), C_prd_cd=substr(lkp.new_thr_pt_acct_nr,4,3), Account_number=lkp.new_thr_pt_acct_nr Where hst.account_number=lkp.old_thr_pt_acct_nr; )by tera; Disconnect from tera; Quit; ... View more

Hi I want to check each row in flag1-flag10 and update a final_final- Accn flag1 flag2 flag3 flag4 flag 5 final_flag 123 y y y n n y 573 n n n n n n 962 n n y n n y I.e from flag1 to flag5 (n) if i get any y then final_flag= y else if all n then only final_flag=n Can anyone help? ... View more

Hi, Please helo me to solve this I have table1 where i have created multiole flag columns which are empty. I have another table2 which will check for the matching of account no and will output the rows which are not matching(matching rows it will remove). So based on output from table 1 i have to update flag columns in table1. I need the output table as- Accno flag1 flag2 flag3 flag4 flag5.......flag20 245789 y n n y y ........ n 678955 n y y y n ......... y 654285 n y y n y .........n Here account no is the total list of account no and flag1 to flag20 are the tables i am checking where i will find that account no..so basically i will update y-yes and n-no if there. Please help Thanks ... View more

I have this sample code-i want to create a column in teradata table when data is updated.please help I have triend using status='updated' in execute block but i am not able to update the table. Proc sql, Connect to tera, %do i=1 to &cnt; Execute(update &table Set &colm=bquote('&&new&i) &colm2=bquote('&&new2&i); %end; Quit; ... View more

Hi, I have 2k text files present in 2k different folders.i want to check for the data in text file where the variable name should be in (name,nm,firname,first_nm,first_name). and all these variable i.e name,nm,firname,first_nm,first_name has a data in it which may be 009871,0987522,x065432,000984631 like this..and if i find this variables present i want to copy the folder containg that text file to different folder.. please help me out how these can be done ... View more

hello,    I am stuck with something please help me out with this.. I have a table as-   wr_no    rfa_no   stk_ref     status 1               1          x             fp 1               2          x             fp 1               1          y             fp 1               1          x             nu 2               1 2               1          x             fp 1               1          x             gd 1               2 1               1          x             gp 1               1          x             gc   I want to create  a flag as 0 for records having status 'nu' i.e for every  'nu' of  stk_ref i want to flag 0  'fp' but not ('gd','gp','gc') with reference to my stk_ref ,wr_no and rfa_no.so basically here i want to flag 0 1st and 4th record  because for the same stk_ref i got 'nu' which has unique  wr_no and unique rfa_no.there are  blank stk_ref and status also for which the flag should be zero.   And the table contains 5billion rows.     ... View more