Demo entry 6346882

SQL

   

Submitted by anonymous on Feb 13, 2017 at 09:20
Language: SQL. Code size: 10.0 kB.

Insert into "t_tlx_info_dupe" (ID,CHANNELNAME,CHANNELNUMBER,STIME,SADDRESS,RTIME,RADDRESS,MD5ID,TLXCONTENT,ISWR,WRREASON,REVSTAT,PROCSTAT,AUTOSTAT,TYPE,CTYP,USEC,CDAT,USEU,LSTU,REMK,DEALSEQSTAT,ROUTECHECK,AUTOSEND,ISWR1,ISWR2,ISWR3,WRREASON1,WRREASON2,WRREASON3,PROCSTAT1,PROCSTAT2,REVSTAT1,REVSTAT2,REVSTAT3,AUTOSTAT1,AUTOSTAT2,AUTOSEND1,AUTOSEND2,ISDUPE,ISREPEAT,ATTR1,ATTR2,ATTR3,ATTR4,STATUS) values ('T2017021015195937e69227ac524d8b8','FMA','5713','20170210071900','XMNUOMF','20170210071900','SHAFP8X','a012e132b223251ed6e6541c6c9db9d1','ZCZC FMA5713 100719  
QU SHAFP8X 
.      
QU XNNZPCA XNNLN8X PEKFP8X SHAFP8X 
.XMNUOMF 100719 
 XIAMEN AIRLINES FLIGHT RELEASE 
MESSAGE TEXT RLS TIME 1702100719 RLS NO ASV1702100429 
CXA8244 1050Z 10-FEB-17 A/C TYPE/B738 REG/B5551 IFR 
ZLXN/ZLXY T/O ALTN NOT REQUIRED 1ST DEST ALTN ZBYN 2ND DEST ALTN 
 ZBYC 
1EO ENROUTE ALTN NOT REQUIRED DEPRESS ENROUTE ALTN ZLXY ZLXN ZLLL 
 ZHCC 
T/O FUEL 7745KG EXTRA FUEL 0KG REQUIRED FUEL 7745KG TRIP FUEL 3139KG 
CREWMEMBER: CHEN JIANWEI  WANG LIANZHONG   
RMK/ 
MEL/CDL MSG 
N/A 
(FPL-CXA8244-IS 
-B738/M-SDE2E3FGHIRWY/LB1 
-ZLXN1050 
-K0850S0950 XNN W111 XIXAN H14 HO 
-ZLXY0105 ZBYN ZBYC 
-PBN/A1B1C1D1L1O1S2 REG/B5551 EET/VISIN0035 
 SEL/AFBD CODE/7806A6 OPR/XIAMEN AIRLINES 
 RMK/ACAS II) 
I HEREBY RELEASE THE FLIGHT IN FULL COMPLIANCE WITH CAAC REGULATIONS 
 AND/OR COMPANY OPERATIONS MANUAL 
DISPATCHER:ZHOURUI 0592 2539915  5739215 
PILOT-IN-COMMAND: 
AMENDMENT LOG: RECORD ANY CHANGES OF INITIAL DISPATCH RELEASE 
TIME..........ITEMS......................PIC..........DISPATCHER..... 
..... 
TIME..........ITEMS......................PIC..........DISPATCHER..... 
..... 
AGENT: 
APPENDIX 
WX INFORMATION 
METAR ZLXN 100700Z VRB01MPS 9999 SCT040 OVC100 M02/M09 Q1023 NOSIG= 
TAF ZLXN 100701Z 100918 12004MPS 8000 SCT040 BKN100 TXM02/09Z 
 TNM08/18Z= 
METAR ZLXY 100700Z 15002MPS 060V210 CAVOK 07/M14 Q1030 NOSIG= 
TAF ZLXY 100716Z 100918 08003MPS 3000 HZ NSC TX07/09Z TNM04/18Z= 
METAR ZBYN 100700Z 18002MPS CAVOK 02/M20 Q1027 NOSIG= 
TAF ZBYN 100706Z 100918 33004MPS 6000 NSC TX02/09Z TNM08/18Z= 
METAR ZBYC 100700Z 28005MPS 240V010 CAVOK 07/M19 Q1031 NOSIG= 
TAF ZBYC 100707Z 100918 30004MPS 5000 HZ NSC TX06/09Z TNM05/18Z= 
METAR ZLLL 100700Z 15002MPS 070V210 CAVOK M01/M13 Q1024 NOSIG= 
TAF ZLLL 100707Z 100918 08003MPS 5000 BR NSC TXM01/09Z TNM08/18Z= 
METAR ZHCC 100700Z 35004MPS CAVOK 09/M19 Q1029 NOSIG= 
TAF ZHCC 100701Z 100918 35004MPS 5000 HZ NSC TX07/09Z TNM01/18Z 
NNNN','0',null,null,'0','0','SITA','FPL','MainMERTXRVSD','20170210151959','TELBUS','20170210152000','AIGN#',null,null,null,'0','0','0',null,null,null,'0','0',null,'SACK-X##',null,'2',null,null,null,'0','0',null,null,null,null,null);
Insert into "t_tlx_info_dupe" (ID,CHANNELNAME,CHANNELNUMBER,STIME,SADDRESS,RTIME,RADDRESS,MD5ID,TLXCONTENT,ISWR,WRREASON,REVSTAT,PROCSTAT,AUTOSTAT,TYPE,CTYP,USEC,CDAT,USEU,LSTU,REMK,DEALSEQSTAT,ROUTECHECK,AUTOSEND,ISWR1,ISWR2,ISWR3,WRREASON1,WRREASON2,WRREASON3,PROCSTAT1,PROCSTAT2,REVSTAT1,REVSTAT2,REVSTAT3,AUTOSTAT1,AUTOSTAT2,AUTOSEND1,AUTOSEND2,ISDUPE,ISREPEAT,ATTR1,ATTR2,ATTR3,ATTR4,STATUS) values ('T20170210151959223074ab50294019a','FMB','5713','20170210071900','XMNUOMF','20170210071900','SHAFP8X','a012e132b223251ed6e6541c6c9db9d1','ZCZC FMB5713 100719  
QU SHAFP8X 
.      
QU XNNZPCA XNNLN8X PEKFP8X SHAFP8X 
.XMNUOMF 100719 
 XIAMEN AIRLINES FLIGHT RELEASE 
MESSAGE TEXT RLS TIME 1702100719 RLS NO ASV1702100429 
CXA8244 1050Z 10-FEB-17 A/C TYPE/B738 REG/B5551 IFR 
ZLXN/ZLXY T/O ALTN NOT REQUIRED 1ST DEST ALTN ZBYN 2ND DEST ALTN 
 ZBYC 
1EO ENROUTE ALTN NOT REQUIRED DEPRESS ENROUTE ALTN ZLXY ZLXN ZLLL 
 ZHCC 
T/O FUEL 7745KG EXTRA FUEL 0KG REQUIRED FUEL 7745KG TRIP FUEL 3139KG 
CREWMEMBER: CHEN JIANWEI  WANG LIANZHONG   
RMK/ 
MEL/CDL MSG 
N/A 
(FPL-CXA8244-IS 
-B738/M-SDE2E3FGHIRWY/LB1 
-ZLXN1050 
-K0850S0950 XNN W111 XIXAN H14 HO 
-ZLXY0105 ZBYN ZBYC 
-PBN/A1B1C1D1L1O1S2 REG/B5551 EET/VISIN0035 
 SEL/AFBD CODE/7806A6 OPR/XIAMEN AIRLINES 
 RMK/ACAS II) 
I HEREBY RELEASE THE FLIGHT IN FULL COMPLIANCE WITH CAAC REGULATIONS 
 AND/OR COMPANY OPERATIONS MANUAL 
DISPATCHER:ZHOURUI 0592 2539915  5739215 
PILOT-IN-COMMAND: 
AMENDMENT LOG: RECORD ANY CHANGES OF INITIAL DISPATCH RELEASE 
TIME..........ITEMS......................PIC..........DISPATCHER..... 
..... 
TIME..........ITEMS......................PIC..........DISPATCHER..... 
..... 
AGENT: 
APPENDIX 
WX INFORMATION 
METAR ZLXN 100700Z VRB01MPS 9999 SCT040 OVC100 M02/M09 Q1023 NOSIG= 
TAF ZLXN 100701Z 100918 12004MPS 8000 SCT040 BKN100 TXM02/09Z 
 TNM08/18Z= 
METAR ZLXY 100700Z 15002MPS 060V210 CAVOK 07/M14 Q1030 NOSIG= 
TAF ZLXY 100716Z 100918 08003MPS 3000 HZ NSC TX07/09Z TNM04/18Z= 
METAR ZBYN 100700Z 18002MPS CAVOK 02/M20 Q1027 NOSIG= 
TAF ZBYN 100706Z 100918 33004MPS 6000 NSC TX02/09Z TNM08/18Z= 
METAR ZBYC 100700Z 28005MPS 240V010 CAVOK 07/M19 Q1031 NOSIG= 
TAF ZBYC 100707Z 100918 30004MPS 5000 HZ NSC TX06/09Z TNM05/18Z= 
METAR ZLLL 100700Z 15002MPS 070V210 CAVOK M01/M13 Q1024 NOSIG= 
TAF ZLLL 100707Z 100918 08003MPS 5000 BR NSC TXM01/09Z TNM08/18Z= 
METAR ZHCC 100700Z 35004MPS CAVOK 09/M19 Q1029 NOSIG= 
TAF ZHCC 100701Z 100918 35004MPS 5000 HZ NSC TX07/09Z TNM01/18Z 
NNNN','0',null,null,'0','0','SITA','FPL','MainMERTXRVSD','20170210151959','MainTXParse','20170210150948','AIGN#',null,null,null,'0','0','0',null,null,null,'0','0','SERR-DUP',null,null,null,null,null,null,'0','1',null,null,null,null,null);
Insert into "t_tlx_info_dupe" (ID,CHANNELNAME,CHANNELNUMBER,STIME,SADDRESS,RTIME,RADDRESS,MD5ID,TLXCONTENT,ISWR,WRREASON,REVSTAT,PROCSTAT,AUTOSTAT,TYPE,CTYP,USEC,CDAT,USEU,LSTU,REMK,DEALSEQSTAT,ROUTECHECK,AUTOSEND,ISWR1,ISWR2,ISWR3,WRREASON1,WRREASON2,WRREASON3,PROCSTAT1,PROCSTAT2,REVSTAT1,REVSTAT2,REVSTAT3,AUTOSTAT1,AUTOSTAT2,AUTOSEND1,AUTOSEND2,ISDUPE,ISREPEAT,ATTR1,ATTR2,ATTR3,ATTR4,STATUS) values ('T20170210153534325d88d4cab146259','FMB','7163','20170210072600','CTUUO3U','20170210073500','SHAZPCA SHAZPCA','88b8c825f096ac47b9d8478b24300b12','ZCZC FMB7163 100735  
QU SHAZPCA SHAZPCA 
.      
QU PEKZPCA SHAFP8X PEKFP8X XUZZPCA XUZTZ8X SHAZPCA PEKFP8X SHAFP8X 
DLCZPCA SHEZPCA DLCKL8X SHAZPCA SHAFP8X PEKFP8X 
.CTUUO3U 100726 
 PLN 11FEB 
346)  10FEB 3U8926 B6845 CAT1 (11) HKT2030 2355CTU 
347)  11FEB 3U8963 B6845 CAT1 (9) CTU0445 0730PVG 
348)  11FEB 3U8964 B6845 CAT1 (9) PVG0835 1220CTU 
349)  10FEB 3U8810 B6899 CAT1 (11) HKT1825 2155CKG 
350)  11FEB 3U8509 B6899 CAT1 (10) CKG0000 0145CGO 
351)  11FEB 3U8510 B6899 CAT1 (10) CGO0240 0435CKG 
352)  11FEB 3U8973 B6899 CAT1 (10) CKG0645 0915PVG 
353)  11FEB 3U8974 B6899 CAT1 (10) PVG1030 1340CKG 
354)  10FEB 3U8669 B6905 CAT1 (9) KMG2335 0110CTU 
355)  11FEB 3U8669 B6905 CAT1 (9) CTU0210 0430SJW 
356)  11FEB 3U8670 B6905 CAT1 (9) SJW0515 0755CTU 
357)  11FEB 3U8670 B6905 CAT1 (9) CTU0855 1030KMG 
358)  11FEB 3U8724 B6905 CAT1 (8) KMG1340 1655PEK 
359)  10FEB 3U8333 B6906 CAT1 (9) CTU2250 0105XUZ 
360)  11FEB 3U8333 B6906 CAT1 (9) XUZ0145 0305DLC 
SI: TO BE CONTINUE 
NNNN','0',null,null,'0','0','SITA','PLN','MainMERTXRVSD','20170210153534','MainTXParse','20170210152523',null,null,null,null,'0','0','0',null,null,null,'0','0','SERR-DUP',null,null,null,null,null,null,'0','1',null,null,null,null,null);
Insert into "t_tlx_info_dupe" (ID,CHANNELNAME,CHANNELNUMBER,STIME,SADDRESS,RTIME,RADDRESS,MD5ID,TLXCONTENT,ISWR,WRREASON,REVSTAT,PROCSTAT,AUTOSTAT,TYPE,CTYP,USEC,CDAT,USEU,LSTU,REMK,DEALSEQSTAT,ROUTECHECK,AUTOSEND,ISWR1,ISWR2,ISWR3,WRREASON1,WRREASON2,WRREASON3,PROCSTAT1,PROCSTAT2,REVSTAT1,REVSTAT2,REVSTAT3,AUTOSTAT1,AUTOSTAT2,AUTOSEND1,AUTOSEND2,ISDUPE,ISREPEAT,ATTR1,ATTR2,ATTR3,ATTR4,STATUS) values ('T2017021015353419df36b643144eb7a','FMA','7162','20170210073500','ZUCKZTZX','20170210073500','ZSHAZMFP','f509acf4489de6dfedb38158a33fd078','ZCZC FMA7162 100735  
FF ZSHAZMFP 
100735 ZUCKZTZX 
 (DEP-CSN3456/A1540-ZUCK0735-ZGSZ-0) 
NNNN','0',null,null,'0','0','AFTN','DEP','MainMERTXRVSD','20170210153534','MainTXParse','20170210152523',null,null,null,null,'0','0','0',null,null,null,'0','0','AERR-DUP',null,null,null,null,null,null,'0','1',null,null,null,null,null);
Insert into "t_tlx_info_dupe" (ID,CHANNELNAME,CHANNELNUMBER,STIME,SADDRESS,RTIME,RADDRESS,MD5ID,TLXCONTENT,ISWR,WRREASON,REVSTAT,PROCSTAT,AUTOSTAT,TYPE,CTYP,USEC,CDAT,USEU,LSTU,REMK,DEALSEQSTAT,ROUTECHECK,AUTOSEND,ISWR1,ISWR2,ISWR3,WRREASON1,WRREASON2,WRREASON3,PROCSTAT1,PROCSTAT2,REVSTAT1,REVSTAT2,REVSTAT3,AUTOSTAT1,AUTOSTAT2,AUTOSEND1,AUTOSEND2,ISDUPE,ISREPEAT,ATTR1,ATTR2,ATTR3,ATTR4,STATUS) values ('T20170210153534b340830c786a4ec99','FMA','7163','20170210072600','CTUUO3U','20170210073500','SHAZPCA SHAZPCA','88b8c825f096ac47b9d8478b24300b12','ZCZC FMA7163 100735  
QU SHAZPCA SHAZPCA 
.      
QU PEKZPCA SHAFP8X PEKFP8X XUZZPCA XUZTZ8X SHAZPCA PEKFP8X SHAFP8X 
DLCZPCA SHEZPCA DLCKL8X SHAZPCA SHAFP8X PEKFP8X 
.CTUUO3U 100726 
 PLN 11FEB 
346)  10FEB 3U8926 B6845 CAT1 (11) HKT2030 2355CTU 
347)  11FEB 3U8963 B6845 CAT1 (9) CTU0445 0730PVG 
348)  11FEB 3U8964 B6845 CAT1 (9) PVG0835 1220CTU 
349)  10FEB 3U8810 B6899 CAT1 (11) HKT1825 2155CKG 
350)  11FEB 3U8509 B6899 CAT1 (10) CKG0000 0145CGO 
351)  11FEB 3U8510 B6899 CAT1 (10) CGO0240 0435CKG 
352)  11FEB 3U8973 B6899 CAT1 (10) CKG0645 0915PVG 
353)  11FEB 3U8974 B6899 CAT1 (10) PVG1030 1340CKG 
354)  10FEB 3U8669 B6905 CAT1 (9) KMG2335 0110CTU 
355)  11FEB 3U8669 B6905 CAT1 (9) CTU0210 0430SJW 
356)  11FEB 3U8670 B6905 CAT1 (9) SJW0515 0755CTU 
357)  11FEB 3U8670 B6905 CAT1 (9) CTU0855 1030KMG 
358)  11FEB 3U8724 B6905 CAT1 (8) KMG1340 1655PEK 
359)  10FEB 3U8333 B6906 CAT1 (9) CTU2250 0105XUZ 
360)  11FEB 3U8333 B6906 CAT1 (9) XUZ0145 0305DLC 
SI: TO BE CONTINUE 
NNNN','0',null,null,'0','0','SITA','PLN','MainMERTXRVSD','20170210153534','MainTXParse','20170210152523',null,null,null,null,'0','0','0',null,null,null,'0','0','SERR-DUP',null,null,null,null,null,null,'0','1',null,null,null,null,null);

This snippet took 0.01 seconds to highlight.

Back to the Entry List or Home.

Delete this entry (admin only).