M Statement Definer Error
Contents |
Login join fields from two files IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL
Mysql Remove Definer
and ICEGENER Post a reply Previous topic • Next topic •
Mysql Definer
8 posts • Page 1 of 1 join fields from two files by muthu455 » Mon Apr 23, mysql definer current_user 2012 3:33 pm i have two files with a key in bytes 1-3 and data in bytes 5-9my first input file is 000 $$$$$001 aaaaa002 ccccc003 eeeee004 gggggmy http://www.ibm.com/support/knowledgecenter/SSLTBW_2.2.0/com.ibm.zos.v2r2.icem100/dfsor.htm second input file is001 bbbbb003 ddddd004 fffff005 hhhhhi want the output like this001 aaaaa bbbbb003 eeeee ddddd004 ggggg fffffi have used the dfsort and joinkey like this//xxxxxAB JOB NOTIFY=&SYSUID //STEP1 EXEC PGM=SORT //SORTIN DD DSN=xxxxx.MUTHU.PS,DISP=SHR //SORTIN1 DD DSN=xxxxxx.MUTHU.PS1,DISP=SHR //SORTOUT DD DSN=xxxxxx.MUTHU.PS2,DISP=OLD //SYSOUT DD SYSOUT=* //SYSIN DD * JOINKEYS F1=SORTIN,FIELDS=(1,3,A),SORTED JOINKEYS F2=SORTIN2,FIELDS=(1,3,A),SORTED REFORMAT FIELDS=(F1:1,9,F2:5,5) OPTION COPY OUTFIL FNAMES=SORTOUT,BUILD=(1,9,X,10,5) http://www.ibmmainframeforum.com/dfsort-icetool-icegener/topic7502.html /* i am getting the maxcc=16 errormy error msg isICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 04:50 ON MON APR JOINKEYS F1=SORTIN,FIELDS=(1,3,A),SORTED $ ICE005A 0 STATEMENT DEFINER ERROR JOINKEYS F2=SORTIN2,FIELDS=(1,3,A),SORTED $ ICE005A 0 STATEMENT DEFINER ERROR REFORMAT FIELDS=(F1:1,9,F2:5,5) $ ICE005A 0 STATEMENT DEFINER ERROR OPTION COPY $ ICE005A 0 STATEMENT DEFINER ERROR OUTFIL FNAMES=SORTOUT,BUILD=(1,9,X,10,5) $ ICE005A 0 STATEMENT DEFINER ERROR ICE010A 0 NO SORT OR MERGE CONTROL STATEMENT ICE751I 0 C5-BASE C6-BASE E7-BASE ICE052I 3 END OF DFSORT please correct my error muthu455 Posts: 21Joined: Sat Apr 14, 2012 3:18 pm Hasthanked: 0 time Beenthanked: 0 time Top Re: join fields from two files Top Re: join fields from two files by BillyBoyo » Mon Apr 23, 2012 3:46 pm Column one of Sort control cards must be left blank.The manuals for DFSORT are available on the web, and clearly describe this. They include a "getting started" guide, to get you started, with clear and well-explained examples.Other than not starting in the correct
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack http://stackoverflow.com/questions/9446783/remove-definer-clause-from-mysql-dumps Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Remove DEFINER clause from MySQL Dumps up vote 37 down vote favorite 26 I have mysql change a MySQL dump of one of my databases. In it, there are DEFINER clauses which look like, "DEFINER=`root`@`localhost`" Namely, these DEFINER clauses are on my CREATE VIEW and CREATE PROCEDURE statements. Is there a way to remove these DEFINER clauses from my dump file? mysql share|improve this question edited Oct 17 '13 at 6:38 Code Lღver 11.9k132959 asked Feb 25 '12 at 18:28 FastTrack 3,05983157 add a comment| 17 Answers 17 m statement definer active oldest votes up vote 40 down vote accepted I don't think there is a way to ignore adding DEFINERs to the dump. But there are ways to remove them after the dump file is created. Open the dump file in a text editor and replace all occurrences of DEFINER=root@localhost with an empty string "" Edit the dump (or pipe the output) using perl: perl -p -i.bak -e "s/DEFINER=\`\w.*\`@\`\d[0-3].*[0-3]\`//g" mydatabase.sql Pipe the output through sed: mysqldump ... | sed -e 's/DEFINER[ ]*=[ ]*[^*]*\*/\*/' > triggers_backup.sql share|improve this answer edited Nov 17 '14 at 23:34 user212218 answered Feb 25 '12 at 19:16 Abhay 4,65711216 Thanks for the response! So in my text editor, would I replace the entire 'DEFINER=root @ localhost' string with ""? Or replace 'root @ localhost'? –FastTrack Feb 25 '12 at 23:02 1 @FastTrack, please remove the entire string. –Abhay Feb 26 '12 at 7:53 1 Worked! Thank you! –FastTrack Feb 27 '12 at 3:05 What if the dump file is 10G? –bksi Oct 8 '14 at 10:37 1 @bksi the sed option should work great as well –usr-local-ΕΨΗΕΛΩΝ Feb 9 '15 at 12:54 | show 6 more comments up vote 14 down vote You can remove using SED sed -i 's/DEFINER=[^*