(14.2) 03-30-15 17:19:28 (15212:42916) REPO: Language got the repository for object is: . (14.2) 03-30-15 17:19:28 (15212:42916) JOB: Reading job from the repository; Server version is <14.2.2.652>; Repository version is <14.2.2.0000>. (14.2) 03-30-15 17:19:28 (15212:42916) JOB: Current directory of job is . (14.2) 03-30-15 17:19:28 (15212:42916) REPO: Language got the repository for object is: < AlGUIComment ("ActaName_1" = 'RSavedAfterCheckOut', "ActaName_2" = 'RDate_modified', "ActaValue_1" = 'YES', "ActaValue_2" = 'Tue Mar 24 09:58:56 2015', "x" = '-1', "y" = '-1') CREATE SESSION job_test::'c2f65ced-b6f2-4299-935c-2c8f192f72e2'( ) BEGIN AlGUIComment ("UI_DATA_XML" = '00216-179 0-1902002000', "x" = '1169', "y" = '-1388') CALL DATAFLOW df_rest::'71ed1c9b-ed42-49ea-971e-1a41d6d8cb82'(); END SET ("job_checkpoint_enabled" = 'no', "job_collect_statistics" = 'no', "job_collect_statistics_monitor" = 'no', "job_enable_assemblers" = 'yes', "job_enable_audit" = 'yes', "job_enable_dataquality" = 'yes', "job_export_repo" = 'no', "job_export_reports" = 'no', "job_guid" = 'c2f65ced-b6f2-4299-935c-2c8f192f72e2', "job_isrecoverable" = 'no', "job_mode" = 'Multi-Process', "job_monitor_sample_rate" = '1000', "job_monitor_timer_rate" = '5', "job_name" = 'job_test', "job_print_version" = 'no', "job_testmode_enabled" = 'no', "job_trace_abapquery" = 'no', "job_trace_all" = 'no', "job_trace_ascomm" = 'no', "job_trace_assemblers" = 'no', "job_trace_audit" = 'no', "job_trace_dataflow" = 'yes', "job_trace_idoc_file" = 'no', "job_trace_memory_loader" = 'no', "job_trace_memory_reader" = 'no', "job_trace_optimized_dataflow" = 'no', "job_trace_parallel_execution" = 'no', "job_trace_rfc_function" = 'no', "job_trace_row" = 'no', "job_trace_script" = 'no', "job_trace_session" = 'yes', "job_trace_sql_only" = 'no', "job_trace_sqlfunctions" = 'no', "job_trace_sqlloaders" = 'no', "job_trace_sqlreaders" = 'no', "job_trace_sqltransforms" = 'no', "job_trace_stored_procedure" = 'no', "job_trace_table" = 'no', "job_trace_table_reader" = 'no', "job_trace_transform" = 'no', "job_trace_userfunction" = 'no', "job_trace_usertransform" = 'no', "job_trace_workflow" = 'yes', "job_type" = 'batch', "job_use_statistics" = 'yes', "locale_codepage" = '', "locale_language" = '', "locale_territory" = '') >. (14.2) 03-30-15 17:19:31 (15212:42916) JOB: Starting job on job server host , port <3500>. (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Saving object in the repository. The SQL generated is: . (14.2) 03-30-15 17:19:31 (15212:42916) JOB: Job of runid <201503301719311521242916> is initiated by user . (14.2) 03-30-15 17:19:31 (15212:42916) JOB: Processing job . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Language got the repository for object is: . (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Language got the repository for object is: < AlGUIComment ("ActaName_1" = 'RSavedAfterCheckOut', "ActaName_2" = 'RDate_created', "ActaName_3" = 'RDate_modified', "ActaValue_1" = 'YES', "ActaValue_2" = 'Fri Mar 20 17:15:43 2015', "ActaValue_3" = 'Mon Mar 30 16:13:26 2015', "x" = '-1', "y" = '-1') CREATE DATAFLOW df_rest::'71ed1c9b-ed42-49ea-971e-1a41d6d8cb82' BEGIN ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '218', "Input_Width_Name" = '295', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Name" = '464', "Output_Width_Type" = '125', "UI_DATA_XML" = '00238-164 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "ui_acta_from_schema_0" = 'Row_Generation', "x" = '1043', "y" = '-1269') GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' CREATE VIEW Query( "DS_1..getAircraftTypes(GET/aircraft/v4/aircraftTypes)" AL_RFC_SCHEMA_GROUP (AircraftTypeResponse AL_NESTED_TABLE (AircraftDefinition AL_NESTED_TABLE (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') ) SET( "Maximum Occurrence" = 'unbounded', "Minimum Occurrence" = '1') ) SET( "Maximum Occurrence" = '1', "Minimum Occurrence" = '1') , AL_ERROR_NUM INT , AL_ERROR_MSG VARCHAR(255) ) ) AS SELECT __AL_TRAN_FUNCTION DS_1.."getAircraftTypes(GET/aircraft/v4/aircraftTypes)"(Row_Generation.DI_ROW_ID)[EMPTYBODY] FROM Row_Generation SET("distinct_run_as_separate_process" = 'no', "group_by_run_as_separate_process" = 'no', "join_run_as_separate_process" = 'no', "order_by_run_as_separate_process" = 'no', "run_as_separate_process" = 'no') ; ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00266-164 0-1752002000', "UpperContainer_HeightProp" = '44', "x" = '512', "y" = '-1288') GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' CALL TRANSFORM Row_Generation() OUTPUT(Row_Generation( DI_ROW_ID INT SET( "Description" = 'The integer type is automatically generated by the Row_Generation transform') ) ) SET("cache" = 'yes', "row_count" = '1', "starting_row_number" = '0', "table_weight" = '0'); ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = '', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00416-183 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "x" = '2296', "y" = '-1275') GUID::'fa8e3600-839d-4dba-a524-af34c16317de' LOAD TABLE DS_ETL_GCMS_INTMD.CNCS_APP_TEAM.RS INPUT(Query_1) SET("connection_port" = 'no', "ldr_configuration_enabled" = 'yes', "ldr_configurations" = ' /127 yes 100000 10 append 1000 , no yes no no compare_by_name yes yes append 1 0 no 0 no no 1000 column_store yes None None None API File None append no write_data no no ', "loader_template_table" = 'yes', "name" = 'DS_ETL_GCMS_INTMD', "use_unicode_varchar" = 'no'); ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00238-164 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "ui_acta_from_schema_0" = 'Query', "x" = '1619', "y" = '-1254') GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' CREATE VIEW Query_1( AircraftTypeResponse AL_UNNEST_SCHEMA_GROUP (AircraftDefinition AL_UNNEST_SCHEMA_GROUP (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) ) ) AS SELECT AL_UNNEST (CREATE VIEW AircraftTypeResponse( AircraftDefinition AL_UNNEST_SCHEMA_GROUP (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) ) AS SELECT AL_UNNEST (CREATE VIEW AircraftDefinition_1( name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) AS SELECT Query.AircraftTypeResponse.AircraftDefinition.name, Query.AircraftTypeResponse.AircraftDefinition.description, Query.AircraftTypeResponse.AircraftDefinition.noOfSeats, Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats, Query.AircraftTypeResponse.AircraftDefinition.isNetJets, Query.AircraftTypeResponse.AircraftDefinition.rank, Query.AircraftTypeResponse.AircraftDefinition.isReleasable FROM Query.AircraftTypeResponse.AircraftDefinition ) FROM Query.AircraftTypeResponse ) FROM Query SET("distinct_run_as_separate_process" = 'no', "group_by_run_as_separate_process" = 'no', "join_run_as_separate_process" = 'no', "order_by_run_as_separate_process" = 'no', "run_as_separate_process" = 'no') ; END SET ("Cache_type" = 'pageable_cache', "Parallelism_degree" = 'default', "allows_both_input_and_output" = 'yes', "dataflow_loader_bulk_load" = 'no', "dataflow_loader_commit_size" = 'default', "dataflow_loader_row_size_bytes" = '0', "dataflow_number_of_loaders" = '0', "run_once" = 'no', "use_dataflow_links" = 'no', "use_datastore_links" = 'yes', "validation_xform_exists" = 'no', "validation_xform_stats" = 'no') >. (14.2) 03-30-15 17:19:31 (15212:42916) PE: Degree of parallelism of data flow is: 0. (14.2) 03-30-15 17:19:31 (15212:42916) PE: Effective degree of parallelism for data flow is: 1. (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Language got the repository for object is: < AlGUIComment ("ActaName_1" = 'RDate_modified', "ActaName_2" = 'RSavedAfterCheckOut', "ActaName_3" = 'RDate_created', "ActaValue_1" = 'Thu Mar 12 14:20:34 2015', "ActaValue_2" = 'YES', "ActaValue_3" = 'Fri Oct 31 09:09:06 2014', "x" = '-1', "y" = '-1') CREATE DATABASE DATASTORE DS_ETL_GCMS_INTMD::'14234201-c2f5-417b-aafe-ab3551cd984c' SET ("DBLiveLoad" = 'no', "application_type" = 'Custom', "cdc_enabled" = 'no', "datastore_repotype" = 'local', "ds_configuration_enabled" = 'yes', "ds_configurations" = ' 28 7 no Oracle no 1000 us-ascii <default> <default> I2RPTDV1 Oracle 11g +04000000001A0301001000002947A191E1F895710F06C05F996F7EEF2390A0B9367AF7E05C948E60A0CECA4526A8F7588CDA3399070B253EF4CA9 424B1B18AB8B817C124B46B3C <default> cncs_app_team ', "enable_data_transfer" = 'yes', "import_unknown_type" = 'no', "name" = 'DS_ETL_GCMS_INTMD', "pcache_force_utf16" = 'no', "unknown_type_size" = '255'); >. (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Language got the repository for object is: . (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Processing View (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:31 (15212:42916) REPO: Language got the repository for object is: < AlGUIComment ("ActaName_1" = 'RSavedAfterCheckOut', "ActaName_2" = 'RDate_created', "ActaValue_1" = 'YES', "ActaValue_2" = 'Mon Mar 30 16:11:20 2015', "x" = '-1', "y" = '-1') CREATE DATABASE DATASTORE DS_1::'3139d75a-217a-43a4-9551-c96e208d19f3' SET ("DBLiveLoad" = 'no', "application_type" = 'web_service_rest', "cdc_enabled" = 'no', "datastore_repotype" = 'local', "ds_configuration_enabled" = 'yes', "ds_configurations" = ' Basic no GET X-CSRF-Token Fetch Adapter client_credentials <default> <default> <default> Plaintext Header String (POST) HMAC-SHA1 "\\u0061\\u0070\\u0070\\u0061\\u0067\\u0065\\u006e\\u0074"="\\u0051\\u0075\\u006f\\u0074\ \u0065\\u0041\\u0070\\u0070\\u006c\\u0069\\u0063\\u0061\\u0074\\u0069\\u006f\\u006e" C:\\rg\\GetAircraft.wadl 0 ', "enable_data_transfer" = 'yes', "import_unknown_type" = 'no', "name" = 'DS_1', "pcache_force_utf16" = 'no', "unknown_type_size" = '255'); >. (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The new project list for view is: < TRANCALL_1_AircraftTypeResponse INT 1 TRANCALL_1_AL_ERROR_NUM INT 2 TRANCALL_1_AL_ERROR_MSG VARCHAR(255) 3> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Processing View (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Processing Sub Query (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Processing Sub Query (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The new project list for view is: < Query.AircraftTypeResponse.AircraftDefinition.name VARCHAR(1024) 1 Query.AircraftTypeResponse.AircraftDefinition.description VARCHAR(1024) 2 Query.AircraftTypeResponse.AircraftDefinition.noOfSeats INT 3 Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats INT 4 Query.AircraftTypeResponse.AircraftDefinition.isNetJets VARCHAR(5) 5 Query.AircraftTypeResponse.AircraftDefinition.rank VARCHAR(1024) 6 Query.AircraftTypeResponse.AircraftDefinition.isReleasable VARCHAR(5) 7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Adding Correlated column whose complete path is to the project list and the output schema of view (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Dataflow For Sub Query is: (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The new project list for view is: < AL_UNNEST_1_2_COL1 VARCHAR(1024) 1 AL_UNNEST_1_2_COL2 VARCHAR(1024) 2 AL_UNNEST_1_2_COL3 INT 3 AL_UNNEST_1_2_COL4 INT 4 AL_UNNEST_1_2_COL5 VARCHAR(5) 5 AL_UNNEST_1_2_COL6 VARCHAR(1024) 6 AL_UNNEST_1_2_COL7 VARCHAR(5) 7 Query.AircraftTypeResponse.AIRCRAFTDEFINITION INT 1> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <1> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Adding Correlated column whose complete path is to the project list and the output schema of view (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Dumping Global Frame: < Column Name: AIRCRAFTDEFINITION Column CoRelation Index: 1 Global Index: 1 View ID: 2 Column Name: AIRCRAFTTYPERESPONSE Column CoRelation Index: 2 Global Index: 2 View ID: 3 > (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Dataflow For Sub Query is: (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The new project list for view is: < AL_UNNEST_1_1_COL1 VARCHAR(1024) 1 AL_UNNEST_1_1_COL2 VARCHAR(1024) 2 AL_UNNEST_1_1_COL3 INT 3 AL_UNNEST_1_1_COL4 INT 4 AL_UNNEST_1_1_COL5 VARCHAR(5) 5 AL_UNNEST_1_1_COL6 VARCHAR(1024) 6 AL_UNNEST_1_1_COL7 VARCHAR(5) 7 Query.AIRCRAFTTYPERESPONSE INT 1> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Dumping Global Frame: < Column Name: AIRCRAFTDEFINITION Column CoRelation Index: 1 Global Index: 1 View ID: 2 Column Name: AIRCRAFTTYPERESPONSE Column CoRelation Index: 2 Global Index: 2 View ID: 3 > (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:31 (15212:42916) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:31 (15212:42916) JOB: Optimizing job . (14.2) 03-30-15 17:19:31 (15212:42916) JOB: Job is started. (14.2) 03-30-15 17:19:31 (15212:42916) JOB: **DEBUG**:System RAM: 24548MB, #cores: 8 (14.2) 03-30-15 17:19:35 (30176:44956) DATAFLOW: Process to execute data flow is started. (14.2) 03-30-15 17:19:35 (30176:44956) PE: Degree of parallelism of data flow is: 0. (14.2) 03-30-15 17:19:35 (30176:44956) PE: Effective degree of parallelism for data flow is: 1. (14.2) 03-30-15 17:19:35 (30176:44956) VIEW: Processing View (14.2) 03-30-15 17:19:35 (30176:44956) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The new project list for view is: < TRANCALL_1_AircraftTypeResponse INT 1 TRANCALL_1_AL_ERROR_NUM INT 2 TRANCALL_1_AL_ERROR_MSG VARCHAR(255) 3> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <3> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Processing View (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Processing Sub Query (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Processing Sub Query (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The new project list for view is: < Query.AircraftTypeResponse.AircraftDefinition.name VARCHAR(1024) 1 Query.AircraftTypeResponse.AircraftDefinition.description VARCHAR(1024) 2 Query.AircraftTypeResponse.AircraftDefinition.noOfSeats INT 3 Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats INT 4 Query.AircraftTypeResponse.AircraftDefinition.isNetJets VARCHAR(5) 5 Query.AircraftTypeResponse.AircraftDefinition.rank VARCHAR(1024) 6 Query.AircraftTypeResponse.AircraftDefinition.isReleasable VARCHAR(5) 7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Adding Correlated column whose complete path is to the project list and the output schema of view (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Dataflow For Sub Query is: (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The new project list for view is: < AL_UNNEST_1_2_COL1 VARCHAR(1024) 1 AL_UNNEST_1_2_COL2 VARCHAR(1024) 2 AL_UNNEST_1_2_COL3 INT 3 AL_UNNEST_1_2_COL4 INT 4 AL_UNNEST_1_2_COL5 VARCHAR(5) 5 AL_UNNEST_1_2_COL6 VARCHAR(1024) 6 AL_UNNEST_1_2_COL7 VARCHAR(5) 7 Query.AircraftTypeResponse.AIRCRAFTDEFINITION INT 1> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <1> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Adding Correlated column whose complete path is to the project list and the output schema of view (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Dumping Global Frame: < Column Name: AIRCRAFTDEFINITION Column CoRelation Index: 1 Global Index: 1 View ID: 2 Column Name: AIRCRAFTTYPERESPONSE Column CoRelation Index: 2 Global Index: 2 View ID: 3 > (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Dataflow For Sub Query is: (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The new project list for view is: < AL_UNNEST_1_1_COL1 VARCHAR(1024) 1 AL_UNNEST_1_1_COL2 VARCHAR(1024) 2 AL_UNNEST_1_1_COL3 INT 3 AL_UNNEST_1_1_COL4 INT 4 AL_UNNEST_1_1_COL5 VARCHAR(5) 5 AL_UNNEST_1_1_COL6 VARCHAR(1024) 6 AL_UNNEST_1_1_COL7 VARCHAR(5) 7 Query.AIRCRAFTTYPERESPONSE INT 1> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Dumping Global Frame: < Column Name: AIRCRAFTDEFINITION Column CoRelation Index: 1 Global Index: 1 View ID: 2 Column Name: AIRCRAFTTYPERESPONSE Column CoRelation Index: 2 Global Index: 2 View ID: 3 > (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: The original project size for view is: <7> (14.2) 03-30-15 17:19:36 (30176:44956) VIEW: Completed processing View . The processed view is: (14.2) 03-30-15 17:19:36 (30176:44956) DATAFLOW: The specified locale has been coerced to for data flow because the datastore obtains data in codepage. (14.2) 03-30-15 17:19:36 (30176:44956) JOB: Initializing transcoder for datastore to transcode between engine codepage and datastore codepage (14.2) 03-30-15 17:19:36 (30176:44956) JOB: Initializing transcoder for datastore to transcode between engine codepage and datastore codepage <> (14.2) 03-30-15 17:19:36 (30176:44956) PE: Pre-parallelization linkage for data flow is: The loader: Query_1_RS:0000000000000000 (0) is connected to GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) is connected to: GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) is connected to: GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) is connected to: GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) is connected to: GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' TRANSFORM Row_Generation[]:00000000034373E0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) is connected to: GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse[]:000000000E6634A0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse.AircraftDefinition[]:000000000AF8C250 (0) . (14.2) 03-30-15 17:19:36 (30176:44956) PE: Post-Micro-Partitioning linkage for data flow is: The loader: Query_1_RS:0000000000000000 (0) is connected to GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) is connected to: GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) is connected to: GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) is connected to: GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) is connected to: GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' TRANSFORM Row_Generation[]:00000000034373E0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) is connected to: GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse[]:000000000E6634A0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse.AircraftDefinition[]:000000000AF8C250 (0) . (14.2) 03-30-15 17:19:36 (30176:44956) PE: Parallelized linkage for data flow is: The loader: Query_1_RS:0000000000000000 (0) is connected to GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:00000000033D7C00 (0) is connected to: GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000AAA6920 (0) is connected to: GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:0000000003437050 (0) is connected to: GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000BF6F460 (0) is connected to: GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' TRANSFORM Row_Generation[]:00000000034373E0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:00000000033D7700 (0) is connected to: GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000353A6C0 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse[]:000000000E6634A0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:00000000033D7200 (0) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse.AircraftDefinition[]:000000000AF8C250 (0) . (14.2) 03-30-15 17:19:36 (30176:44956) PE: Testing whether or not operations in sub data flow are memory-intensive. (14.2) 03-30-15 17:19:36 (30176:44956) PE: Inserting Inter-Process Communications (IPC) points for sub data flow . (14.2) 03-30-15 17:19:36 (30176:44956) OPTIMIZE: Optimized plan for data flow is: CREATE DATAFLOW df_rest_1 BEGIN ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = '', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00416-183 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "x" = '2296', "y" = '-1275') GUID::'fa8e3600-839d-4dba-a524-af34c16317de' LOAD TABLE DS_ETL_GCMS_INTMD.CNCS_APP_TEAM.RS INPUT(Query_1) SET("Table_Type" = '', "bulk_col_delimiter" = '/127', "bulk_ldr_cleanup" = 'yes', "bulk_ldr_max_bind_array" = '100000', "bulk_ldr_max_discards" = '10', "bulk_ldr_mode" = 'append', "bulk_ldr_rows_per_commit" = '1000', "column_delimiter" = ',', "connection_port" = 'no', "enable_partitioning" = 'no', "ignore_column_case" = 'yes', "ignore_columns_null" = 'no', "ldr_configuration_enabled" = 'yes', "ldr_configurations" = ' /127 yes 100000 10 append 1000 , no yes no no compare_by_name yes yes append 1 0 no 0 no no 1000 column_store yes None None None API File None append no write_data no no ', "loader_auto_correct" = 'no', "loader_compare_column" = 'compare_by_name', "loader_drop_and_create_table" = 'yes', "loader_insert_select_commit_size" = 'yes', "loader_load_choice" = 'append', "loader_num_parallel_loaders" = '1', "loader_quote_names" = '0', "loader_template_table" = 'yes', "loader_transactional" = 'no', "loader_transactional_order" = '0', "loader_update_key_columns" = 'no', "loader_use_user_defined_keys" = 'no', "loader_xact_size" = '1000', "name" = 'DS_ETL_GCMS_INTMD', "newdb_table_type" = 'column_store', "oracle_auto_correct_using_merge" = 'yes', "oracle_bulk_ldr_all_method" = 'None', "oracle_bulk_ldr_file_method" = 'None', "oracle_bulk_ldr_method" = 'None', "oracle_bulk_ldr_method_api" = 'API', "oracle_bulk_ldr_method_file" = 'File', "oracle_bulk_ldr_method_none" = 'None', "oracle_bulk_ldr_mode_api" = 'append', "oracle_bulk_ldr_use_local_index_for_pkey" = 'no', "overflow_file_format" = 'write_data', "use_overflow_file" = 'no', "use_unicode_varchar" = 'no'); ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00238-164 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "ui_acta_from_schema_0" = 'Query', "x" = '1619', "y" = '-1254') GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' CREATE VIEW Query_1( name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) AS SELECT "Query_1-Nest2".AIColumn4, "Query_1-Nest2".AIColumn5, "Query_1-Nest2".AIColumn6, "Query_1-Nest2".AIColumn7, "Query_1-Nest2".AIColumn8, "Query_1-Nest2".AIColumn9, "Query_1-Nest2".AIColumn10 FROM "Query_1-Nest2" ( SET("cache" = 'yes') ) SET("distinct_run_as_separate_process" = 'no', "group_by_run_as_separate_process" = 'no', "join_run_as_separate_process" = 'no', "order_by_run_as_separate_process" = 'no', "run_as_separate_process" = 'no') ; GUID::'5a73b57f-0817-42be-8d63-b07996c26452' CREATE VIEW "Query_1-Nest2"( AIColumn4 VARCHAR(1024) , AIColumn5 VARCHAR(1024) , AIColumn6 INT , AIColumn7 INT , AIColumn8 VARCHAR(5) , AIColumn9 VARCHAR(1024) , AIColumn10 VARCHAR(5) , AIColumn11 AL_NESTED_TABLE (AircraftDefinition AL_NESTED_TABLE (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') ) SET( "Maximum Occurrence" = 'unbounded', "Minimum Occurrence" = '1') ) ) AS SELECT AircraftTypeResponse.name, AircraftTypeResponse.description, AircraftTypeResponse.noOfSeats, AircraftTypeResponse.noOfSpecialSeats, AircraftTypeResponse.isNetJets, AircraftTypeResponse.rank, AircraftTypeResponse.isReleasable, Query.AIRCRAFTTYPERESPONSE FROM Query ( SET("cache" = 'yes') ) ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '218', "Input_Width_Name" = '295', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Name" = '464', "Output_Width_Type" = '125', "UI_DATA_XML" = '00238-164 0-1752002000', "UI_PASSTHRU_VSPLIT_PCT" = '50', "UpperContainer_HeightProp" = '44', "ui_acta_from_schema_0" = 'Row_Generation', "x" = '1043', "y" = '-1269') GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' CREATE VIEW Query( AircraftTypeResponse AL_NESTED_TABLE (AircraftDefinition AL_NESTED_TABLE (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') ) SET( "Maximum Occurrence" = 'unbounded', "Minimum Occurrence" = '1') ) SET( "Maximum Occurrence" = '1', "Minimum Occurrence" = '1') , AL_ERROR_NUM INT , AL_ERROR_MSG VARCHAR(255) ) AS SELECT "Query-Function1".AIColumn1, "Query-Function1".AIColumn2, "Query-Function1".AIColumn3 FROM "Query-Function1" ( SET("cache" = 'yes') ) SET("distinct_run_as_separate_process" = 'no', "group_by_run_as_separate_process" = 'no', "join_run_as_separate_process" = 'no', "order_by_run_as_separate_process" = 'no', "run_as_separate_process" = 'no') ; GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' CREATE VIEW "Query-Function1"( AIColumn1 INT , AIColumn2 INT , AIColumn3 VARCHAR(255) , DI_ROW_ID INT ) AS SELECT TRANCALL_1_AircraftTypeResponse, TRANCALL_1_AL_ERROR_NUM, TRANCALL_1_AL_ERROR_MSG, Row_Generation.DI_ROW_ID FROM Row_Generation ( SET("cache" = 'yes') ) ; ALGUIComment ("InputSchema_WidthProp" = '39', "Input_1st_Column_Name" = 'Type', "Input_2nd_Column_Name" = 'Description', "Input_Column_Name_3" = 'Content_Type', "Input_Column_Name_4" = 'Business_Name', "Input_Column_Width_3" = '100', "Input_Column_Width_4" = '100', "Input_Width_Description" = '130', "Input_Width_Type" = '85', "Output_1st_Column_Name" = 'Type', "Output_2nd_Column_Name" = 'Mapping', "Output_3rd_Column_Name" = 'Description', "Output_Column_Name_4" = 'Content_Type', "Output_Column_Name_5" = 'Business_Name', "Output_Column_Width_4" = '100', "Output_Column_Width_5" = '100', "Output_Width_Decsription" = '130', "Output_Width_Mapping" = '85', "Output_Width_Type" = '80', "UI_DATA_XML" = '00266-164 0-1752002000', "UpperContainer_HeightProp" = '44', "x" = '512', "y" = '-1288') GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' CALL TRANSFORM Row_Generation('1', '0') OUTPUT(Row_Generation( DI_ROW_ID INT ) ) SET("cache" = 'yes', "row_count" = '1', "starting_row_number" = '0', "table_weight" = '0'); GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' CREATE VIEW AircraftTypeResponse( name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) AS SELECT "AircraftTypeResponse-Nest3".AIColumn12, "AircraftTypeResponse-Nest3".AIColumn13, "AircraftTypeResponse-Nest3".AIColumn14, "AircraftTypeResponse-Nest3".AIColumn15, "AircraftTypeResponse-Nest3".AIColumn16, "AircraftTypeResponse-Nest3".AIColumn17, "AircraftTypeResponse-Nest3".AIColumn18 FROM "AircraftTypeResponse-Nest3" ( SET("cache" = 'yes') ) GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' CREATE VIEW "AircraftTypeResponse-Nest3"( AIColumn12 VARCHAR(1024) , AIColumn13 VARCHAR(1024) , AIColumn14 INT , AIColumn15 INT , AIColumn16 VARCHAR(5) , AIColumn17 VARCHAR(1024) , AIColumn18 VARCHAR(5) , AIColumn19 AL_NESTED_TABLE (name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT') ) ) AS SELECT AircraftDefinition_1.name, AircraftDefinition_1.description, AircraftDefinition_1.noOfSeats, AircraftDefinition_1.noOfSpecialSeats, AircraftDefinition_1.isNetJets, AircraftDefinition_1.rank, AircraftDefinition_1.isReleasable, Query.AircraftTypeResponse.AIRCRAFTDEFINITION FROM Query.AircraftTypeResponse ( SET("cache" = 'yes') ) READ __MEMORY TABLE Query.AircraftTypeResponse OUTPUT("Query.AircraftTypeResponse") SET(); GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' CREATE VIEW AircraftDefinition_1( name VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.name') , description VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.description') , noOfSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSeats') , noOfSpecialSeats INT SET( "Max Value Inclusive Of" = '2147483647', "Min Value Inclusive Of" = '-2147483648', "Native Type" = 'int', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats') , isNetJets VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isNetJets') , rank VARCHAR(1024) SET( "Native Type" = 'String', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.rank') , isReleasable VARCHAR(5) SET( "Native Type" = 'Boolean', "XML Type" = 'ELEMENT', "ui_mapping_text" = 'Query.AircraftTypeResponse.AircraftDefinition.isReleasable') ) AS SELECT Query.AircraftTypeResponse.AircraftDefinition.name, Query.AircraftTypeResponse.AircraftDefinition.description, Query.AircraftTypeResponse.AircraftDefinition.noOfSeats, Query.AircraftTypeResponse.AircraftDefinition.noOfSpecialSeats, Query.AircraftTypeResponse.AircraftDefinition.isNetJets, Query.AircraftTypeResponse.AircraftDefinition.rank, Query.AircraftTypeResponse.AircraftDefinition.isReleasable FROM Query.AircraftTypeResponse.AircraftDefinition ( SET("cache" = 'yes') ) READ __MEMORY TABLE Query.AircraftTypeResponse.AircraftDefinition OUTPUT("Query.AircraftTypeResponse.AircraftDefinition") SET(); END SET ("Cache_type" = 'pageable_cache', "Parallelism_degree" = 'default', "allows_both_input_and_output" = 'yes', "dataflow_loader_bulk_load" = 'no', "dataflow_loader_commit_size" = 'default', "dataflow_loader_row_size_bytes" = '0', "dataflow_number_of_loaders" = '0', "run_once" = 'no', "use_dataflow_links" = 'no', "use_datastore_links" = 'yes', "validation_xform_exists" = 'no', "validation_xform_stats" = 'no') (14.2) 03-30-15 17:19:36 (30176:44956) OPTIMIZE: Optimized linkage for data flow is: The loader: Query_1_RS:000000000E6CDAF0 (0) is connected to GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:000000000E66A520 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY Query_1 - Project:000000000E66A520 (0) is connected to: GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000C7400A0 (0) GUID::'5a73b57f-0817-42be-8d63-b07996c26452' QUERY Query_1-Nest2 - Contains NestedViews:000000000C7400A0 (0) is connected to: GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:00000000022746B0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:000000000DF2BCB0 (1) GUID::'4c25666c-55ed-4948-bf3e-28ef8b12a8fa' QUERY Query - Project:00000000022746B0 (0) is connected to: GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000DF29EE0 (0) GUID::'cc175e8b-73b9-4372-91d8-b906f1160810' QUERY Query-Function1 - Project:000000000DF29EE0 (0) is connected to: GUID::'6e100aaf-2a0a-44b9-9cb1-c08a9827aa10' TRANSFORM Row_Generation[]:000000000ADAE0E0 (0) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftTypeResponse - Project:000000000DF2BCB0 (1) is connected to: GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000C73F770 (1) GUID::'d9ae27da-ac47-4c60-8f2f-d45df8f97a37' QUERY AircraftTypeResponse-Nest3 - Contains NestedViews:000000000C73F770 (1) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse[]:000000000C946A20 (1) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:000000000E669A80 (1) GUID::'41ff0488-6594-457e-9c10-755aefb6ef65' QUERY AircraftDefinition_1 - regular view:000000000E669A80 (1) is connected to: READ MEMORY TABLE Query.AircraftTypeResponse.AircraftDefinition[]:000000000E66B810 (1) (14.2) 03-30-15 17:19:36 (30176:44956) DATAFLOW: Data flow is started. (14.2) 03-30-15 17:19:36 (30176:44956) DATAFLOW: Data flow can not use PAGEABLE because it has nested schema. Switching cache type to IN MEMORY. (14.2) 03-30-15 17:19:36 (30176:44956) DATAFLOW: Data flow using IN MEMORY Cache. (14.2) 03-30-15 17:19:36 (30176:44956) SQLLOAD: SQL submitted from loader in is: DROP TABLE "CNCS_APP_TEAM"."RS" PURGE . (14.2) 03-30-15 17:19:36 (30176:44956) TABLE: Table is dropped for user from datastore . (14.2) 03-30-15 17:19:36 (30176:44956) SQLLOAD: SQL submitted from loader in is: DECLARE sql_stmt varchar2(32767); cursor_name integer; table_exists EXCEPTION; PRAGMA EXCEPTION_INIT (table_exists, -955); err_msg varchar2(100); BEGIN cursor_name := dbms_sql.open_cursor; sql_stmt := 'CREATE TABLE "CNCS_APP_TEAM"."RS" ( "NAME" varchar (1024) null , "DESCRIPTION" varchar (1024) null , "NOOFSEATS" integer null , "NOOFSPECIALSEATS" integer null , "ISNETJETS" varchar (5) null , "RANK" varchar (1024) null , "ISRELEASABLE" varchar (5) null )'; dbms_sql.parse(cursor_name, sql_stmt, dbms_sql.native); dbms_sql.close_cursor(cursor_name); EXCEPTION WHEN table_exists THEN err_msg := substr(sqlerrm, 1, 100); raise_application_error (-20001, err_msg); WHEN others THEN err_msg := substr(sqlerrm, 1, 100); raise_application_error (-20002, err_msg); END; . (14.2) 03-30-15 17:19:36 (30176:44956) TABLE: Table is created for user in datastore . (14.2) 03-30-15 17:19:36 (30176:16236) TRAN: Transform is started. (14.2) 03-30-15 17:19:36 (30176:16236) ROW: Transform is exporting row <0>. (14.2) 03-30-15 17:19:36 (30176:16236) ROW: Transform is exporting EOS row <>. (14.2) 03-30-15 17:19:36 (30176:19856) TRAN: Transform is started. (14.2) 03-30-15 17:19:36 (30176:19856) ROW: Transform is importing row <0>. (14.2) 03-30-15 17:19:36 (30176:44564) TRAN: Transform is started. (14.2) 03-30-15 17:19:36 (30176:32160) TRAN: Transform is started. (14.2) 03-30-15 17:19:36 (30176:19856) TRAN: GET /aircraft/v4/aircraftTypes HTTP/1.1 Host: servicesdev.netjets.com Content-Type: application/json; charset=utf-8 Accept: application/json appagent: QuoteApplication (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: HTTP/1.1 200 OK (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Server: Apache-Coyote/1.1 (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Set-Cookie ******* (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Content-Type: application/json;charset=UTF-8 (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Transfer-Encoding: chunked (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Date: Mon, 30 Mar 2015 21:19:30 GMT (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: 2000 [{"name":"1","description":"PC12","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name" :"A 310","description":"Airbus 310","noOfSeats":null,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"A 318","description":"Airbus 318 Elite","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"A 319","description":"Airbus Corporate Jet","noOfSeats":30,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"A 320","description":"Airbus A320","noOfSeats":150,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"AC-500","description":"A ERO COMMANDER","noOfSeats":5,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AC-90","description":" Turbo Commander","noOfSeats":5,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AEROCOMM","description ":"AERO COMMANDER 690B","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"AEROSTAR","description":"A EROSTAR","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AG-109A","description":" AGUSTA 109","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"ALL","description":"ALL Types for Airport Alert","noOfSeats":5,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"AS 355 N","description":"DAUPHIN - Delete","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"AS-350D","description":" A-STAR","noOfSeats":2,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AS-355","description":"TW IN STAR","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AS-355 N","description":"DAUPHIN","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"AS-36 5 N2","description":"DAUPHIN","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"AS-36 5N2","description":"Dauphin","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"AW-1 39","description":"AGUSTA WESTLAND 139","noOfSeats":15,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-707","description":"BOEI NG 707","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-727","description":"BOEIN G 727","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"B-727-200","description":"BO EING 727-200","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-727-300","descriptio n":"BOEING 727-300","noOfSeats":40,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-737-100","descriptio n":"BOEING 737-100","noOfSeats":40,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"B-737-300","description ":"Boeing 737-300","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"B-737-400","description" :"Boeing 737-400","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-737-700","description ":"BOEING 737-700 / BBJ","noOfSeats":18,"noOfSpecialSeats":0,"isNetJets":true,"rank":1,"isReleasable":true},{"name":"B-737-800","description":"BOEIN G 737-800 / BBJ","noOfSeats":18,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"B-747-400","description":"B oeing 747-400","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"B-757","description":"B oeing 757","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"B-757-200","description":"BO EING 757","noOfSeats":63,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"B-767-200","description":"B OEING 767-200","noOfSeats":102,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BA-700","description" :"HAWKER 700 - DELETE","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BAC-111","description":"B AC 111","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BAE-1000A","description":"H AWKER 1000","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":true,"rank":44,"isReleasable":false},{"name":"BAE-800XP","description":"HAW KER 800XP","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BAE-850XP","description":" Hawker 850XP","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BD-700-1A10","description ":"GLOBAL","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BD-700-1A10X","descrip tion":"Global XRS","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BD-700-1A11","description": "GLOBAL 5000","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"BE-100","description":"KIN GAIR 100","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-1300","description":"KING AIR 200-HDC","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-1900","description":" BEECH 1900","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-200","description":"KIN GAIR 200","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":true,"rank":85,"isReleasable":false},{"name":"BE-300","description":"KING AIR 300","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-350","description":"KING AIR 350","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-390","description":"Premi er- IA","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BE-400","description":"BEECH JET 400","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BE-400/400A","description": "BEECHJET 400A","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-400A","description":"HAW KER 400XP","noOfSeats":7,"noOfSpecialSeats":1,"isNetJets":true,"rank":68,"isReleasable":true},{"name":"BE-58","description":"BARON", "noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-58P","description":"FIXED TWIN PISTON PRESSURIZED","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-60","description" :"BARON 60","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-90","description":"KING AIR 90","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-90C","description":"KING AIR 90C","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BE-90F","description":"KING AIR 90-F","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BN-2A","description":"Islan der","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"BN-2A-20","description":"I SLANDER","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"BO-105","description":"B olkow 105","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"C-208","description":"Carav an","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"C-402","description":"CESSNA 402","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"C-404","description":"CESSNA 404","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"C-414","description":"CESSNA 41 2000 4","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"C-421","description":"CESSNA 421","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"C-425","description":"CESSNA 425 CONQUEST","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-172","description":" CESSNA 172","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-172S","descript (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: i (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: on":"Cessna 172S","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-208B","description":"CE SSNA GRAND CARAVAN","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-310","description":" CESSNA 310","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-340A","description":"CESS NA 340A","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-402B","description":"CES SNA BUSINESS/UTILINER","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-441","descr iption":"CONQUEST II","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-500","description":"CITATI ON I","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-501","description":"CITATIO N I","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-510","description":"CITATIO N MUSTANG","noOfSeats":5,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-525","description":" CITATIONJET","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-525A","descriptio n":"CITATIONJET II","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-525B","description":"CITA TIONJET 3","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-525C","description":"CITAT IONJET 4","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CE-550","description":"CITATI ON II","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-550B","description":"CITAT ION BRAVO","noOfSeats":7,"noOfSpecialSeats":1,"isNetJets":true,"rank":75,"isReleasable":true},{"name":"CE-560","description":"CITATI ON V ULTRA","noOfSeats":7,"noOfSpecialSeats":1,"isNetJets":true,"rank":70,"isReleasable":true},{"name":"CE-560 Ultra","description":"CITATION V ULTRA (Delete)","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-560E","description": "CITATION ENCORE","noOfSeats":7,"noOfSpecialSeats":1,"isNetJets":true,"rank":65,"isReleasable":true},{"name":"CE-560EP","description":"CIT ATION ENCORE PLUS","noOfSeats":7,"noOfSpecialSeats":1,"isNetJets":true,"rank":64,"isReleasable":true},{"name":"CE-560V","description":"CITATI ON V","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-560XL","description":"CITAT ION EXCEL","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":true,"rank":60,"isReleasable":true},{"name":"CE-560XLS","description":"CIT ATION EXCEL/XLS","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":true,"rank":61,"isReleasable":true},{"name":"CE-560XLSP","description" :"CITATION EXCEL/XLS PLUS","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"CE-650","description":"CITA TION VII","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":55,"isReleasable":true},{"name":"CE-650/III","description":"CITA TION III","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-650/VI","description":"CI TATION VI","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CE-680","description":"CITATI ON SOVEREIGN","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":45,"isReleasable":true},{"name":"CE-750","description":"CI TATION X","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":40,"isReleasable":true},{"name":"CE-S550","description":"CITATION SII","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":80,"isReleasable":true},{"name":"CL-300","description":"Challeng er 300","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CL-350S","description":"Ch allenger 350 Signature","noOfSeats":9,"noOfSpecialSeats":1,"isNetJets":true,"rank":30,"isReleasable":true},{"name":"CL-600","description":"CH ALLENGER 600","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CL-600-2B16","description": "Challenger 604 - DO NOT USE","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CL-601","description":"CHAL LENGER 601","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CL-601-3A","description":"C HALLENGER 601-3R","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CL-604","description":" CHALLENGER 604","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"CL-605","description":"CHALL ENGER 605","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CL-650S","description":"Ch allenger 650 Signature","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CLSE","description":" Challenger SE","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"CRJ-100","description":"CANA DAIR REGIONAL JET","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"D-328","description":"DORNIE R 328","noOfSeats":29,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DA-10","description":"FALCO N 10XXXX","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DA-20","description":"FAL CON 20XXXX","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DA-2000","description":"F ALCON 2000","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":true,"rank":21,"isReleasable":true},{"name":"DA-2000EX","description":"FAL CON 2000EX","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-2000LX","description ":"FALCON 2000 LX","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-2EASY","description":"FA LCON 2000EXEASY","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":true,"rank":20,"isReleasable":true},{"name":"DA-50","description":"F ALCON 50","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":true,"rank":46,"isReleasable":true},{"name":"DA-50EX","description":"FALCON 50EX","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-7X","description":"FALC ON 7X","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":5,"isReleasable":true},{"name":"DA-900","description":"FALCON 900B","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":true,"rank":25,"isReleasable":true},{"name":"DA-900 EX","description":"FALON 900EX - DON'T USE","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DA-900C","description":"FAL CON 900C","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-900DX","description":" FALCON 900DX","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-900EX","description": "FALCON 900EX","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":30,"isReleasable":false},{"name":"DA-900EX-W","description": "FALCON 900EX w/API Winglets","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"DA-900LX","descriptio n":"FALCON 900LX","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":0,"i 2000 sReleasable":true},{"name":"DA-9EASY","description":"FALCON 900EX EASY","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"DC-3","description":"DOUGL AS DC-3","noOfSeats":5,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DC-9","description":"DC-9", "noOfSeats":42,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"DHC-7","description":"DASH 7","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"EC-120B","description":"COLIBR I","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"EC-135","description":"Eurocop ter","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"EC-155-B1","description":"E urocopter","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"EM-110","description" :"EMBRAER BANDIT","noOfSeats":15,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"EMB-100","description":" Phenom 100","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"EMB-135-BJ","description":" Legacy","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isRel (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: e (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: asable":false},{"name":"EMB-145-XR","description":"ERJ-145XR","noOfSeats":50,"noOfSpecialSeats":0,"isNetJets":false,"rank":null, "isReleasable":false},{"name":"EMB-190","description":"ERJ-190","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null ,"isReleasable":false},{"name":"EMB-505","description":"Phenom 300","noOfSeats":6,"noOfSpecialSeats":1,"isNetJets":true,"rank":63,"isReleasable":true},{"name":"EMB-505S","description":"Phenom 300 Signature","noOfSeats":6,"noOfSpecialSeats":1,"isNetJets":true,"rank":62,"isReleasable":true},{"name":"F-100","description":"FOK KER 100","noOfSeats":null,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G-100","description":"GU LFSTREAM 100","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"G-1159","description":"GULFS TREAM II","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"G-1159A","description":"GULF STREAM III","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"G-1159B","description":"GUL FSTREAM IIB","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"G-1159SP","description":"GU LFSTREAM IISP","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"G-150","description":"GULF STREAM 150 - DO NOT USE!","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G-200","description":"GULF STREAM 200","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":true,"rank":35,"isReleasable":true},{"name":"G-280","description":"Gulfstrea m G280","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G-300","description":"GULF STREAM 300","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"G-350","description":"Gulfs tream 350","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G-400","description":"GULF STREAM 400","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G-450","description":"GULF STREAM 450","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":12,"isReleasable":true},{"name":"G-550","description":"GULFSTRE AM 550","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":3,"isReleasable":true},{"name":"G-650","description":"Gulfstrea m 650","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"G150","description":"Gulfst ream G150","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"GIV","description":"GULFSTR EAM IV","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"GIV-SP","description":"GULFS TREAM IV/SP","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":true,"rank":15,"isReleasable":true},{"name":"GL5000S","description":"Glob al 5000 Signature","noOfSeats":13,"noOfSpecialSeats":0,"isNetJets":true,"rank":7,"isReleasable":true},{"name":"GL6000S","description":"G lobal 6000 Signature","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":2,"isReleasable":true},{"name":"GV","description":"GULFST REAM V","noOfSeats":14,"noOfSpecialSeats":0,"isNetJets":true,"rank":4,"isReleasable":true},{"name":"H4000","description":"HAWKER 4000","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":41,"isReleasable":true},{"name":"HB-206","description":"JET RANGER 206","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HB-206L","description":"LONG RANGER 206L","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HB-407","description":"Bell 407","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HB-412","description":"BELL 412","noOfSeats":10,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HB-430","description":"Bell 430","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HEAVY","description":"Heavy" ,"noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"HS-125-400","description":"HAWK ER SIDDELEY 400","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-400/731","description ":"HAWKER SIDDELEY 400/731","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-600","description ":"HAWKER SIDDELEY 600","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-600/731","description ":"HAWKER SIDDELEY 600/731","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-700","description ":"HAWKER 700","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-750","description":"H awker 750","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":48,"isReleasable":true},{"name":"HS-125-800","description":"HAWK ER 800","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"HS-125-800XP","description": "HAWKER 800XP","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":50,"isReleasable":true},{"name":"HS-125-800XPC","description": "HAWKER 800XP - Collins","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":51,"isReleasable":true},{"name":"HS-125-900XP","description" :"HAWKER 900XP","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":true,"rank":47,"isReleasable":true},{"name":"HS-400","description":"HAWKER SIDDELEY 400","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"HS-400/731","description":" HAWKER 400","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"HS-600","description":"HAWK ER SIDDELEY 600","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"HS-600/731","description":" HAWKER SIDDELEY 600/731","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"HS-700","description":" HAWKER 700","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"IAI-1124","description":"WE STWIND 1","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"IAI-1124A","description":"WEST WIND 2","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"IAI-1125","description":"Astra ","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"IAI-1125A","description":"ASTRA SPX","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null," 2000 isReleasable":false},{"name":"J-31","description":"JETSTREAM SUPER 31","noOfSeats":19,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"JC-1121B","description":"JET COMMANDER","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"L-1329-25","descriptio n":"JETSTAR II","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"L-1329-731","description":"JE TSTAR 731","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LARGE","description":"Large" ,"noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LJ75","description":"LEARJET 75","noOfSeats":9,"noOfSpecialSeats":1,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LR-23","description":"LEARJE T (Delete)","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-24","description":"L EARJET 24 (Delete)","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-25","description":"L EARJET 25 (Delete)","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-25D","description":" LEARJET 25D (Delete)","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-25XR","description": "LEARJET 25XR (Delete)","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-28","description":"L EARJET 28 (Delete)","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-31","description":"L earjet 31","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-31A","description":"Learje t 31A","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-35","description":"Learje t 35","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-35A","description":"LEARJE T 35A","noOfSeats":8,"noOfSpecialSeats": (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: 0 (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: ,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-36","description":"LEARJET 36","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-36A","description":"LEARJE T 36A","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LR-40","description":"Learj et 40","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LR-40XR","description":"Lear jet 40XR","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LR-45","description":"Lear jet 45","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-45XR","description":"Learj et 45XR","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"LR-55","description":"LEAR JET 55","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-55C","description":"LEARJE T 55C","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-60","description":"LEARJE T 60","noOfSeats":6,"noOfSpecialSeats":1,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"LR-60XR","description":"LEARJ ET 60XR","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"MD 83","description":"Macdonnell Douglas","noOfSeats":null,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"MD-10","description" :"FALCON 10","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"MD-100","description":"FALCO N 100","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MD-20","description":"FALCON 731 20B","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"MD-200","description":"FALC ON 200","noOfSeats":9,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MD-2000","description":"FALC ON 2000XXXX","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MD-50","description":"F ALCON 50XXXX","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MD-900","description":"FA LCON 900XXXX","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MD-900 EX","description":"FALON 900 EX XXXX","noOfSeats":12,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MID","description":"Midsiz e","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"MU-2","description":"MITSUBIS HI/T-PROP","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"MU-300","description": "DIAMONDJET","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"NA-265","description ":"SABRELINER-65","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"NJE HS-125-800X","description":"HAWKER 800XP","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"P180","description":"Avant i","noOfSeats":7,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"PA-23-250","description":"AZT EC","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"PA-31","description":"NAVAJO" ,"noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"PA-31-350","description":"CHIEFT AIN","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"PA-31T","description":"CHEYE NNE","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"PA-42","description":"CHEYAN NE III","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"PC-12","description":"PILATU S PC-12","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"R-44","description":"ROBIN SON 44","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"RA-390","description":"Premie r-IA","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"S-76A","description":"SIKO RSKY 76A","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"S-76B","description":"SIKORS KY S-76B","noOfSeats":4,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"S-76C","description":"SIK ORSKY S-76C+","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"S-92","description":"SIK ORSKY 92","noOfSeats":null,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SA 365 N","description":"DAUPHIN","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SA 365 N1","description":"DAUPHIN HELICOPTER","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SA 365 N3","description":"DAUPHIN","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SA-2 26-AT","description":"MERLIN IVA","noOfSeats":3,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"SF-340","description":"SAAB 340","noOfSeats":34,"noOfSpecialSeats":0,"isNetJets":false,"rank":999,"isReleasable":false},{"name":"SK-76B","description":"Siko rsky 76B","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SMALL","description":"Small ","noOfSeats":6,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SUPER MID","description":"Super Midsize","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"SW-227-TT","description ":"MERLIN IIIB","noOfSeats":8,"noOfSpecialSeats":0,"isNet 30a Jets":false,"rank":999,"isReleasable":false},{"name":"TRAINING","description":"TRAINING CLASS TYPE","noOfSeats":null,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":true},{"name":"XMISC OPS","description":"Miscellaneous Operations Activity","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"XMISC TRNG","description":"Miscellaneous Training Activity","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"XSIM","description":"F LIGHT SIMULATOR","noOfSeats":0,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false},{"name":"XSUB.CON","descriptio n":"SUB-CONTRACTED SII","noOfSeats":8,"noOfSpecialSeats":0,"isNetJets":false,"rank":null,"isReleasable":false}] 0 (14.2) 03-30-15 17:19:37 (30176:19856) ROW: Transform is exporting row <,0,NULL,0>. (14.2) 03-30-15 17:19:37 (30176:19856) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:19856) ROW: Transform is exporting EOS row <>. (14.2) 03-30-15 17:19:37 (30176:44564) ROW: Transform is importing row <,0,NULL,0>. (14.2) 03-30-15 17:19:37 (30176:44564) ROW: Transform is exporting row <,0,NULL>. (14.2) 03-30-15 17:19:37 (30176:44564) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:44564) ROW: Transform is exporting EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row <,0,NULL>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row . (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row . (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row . (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing row . (14.2) 03-30-15 17:19:37 (30176:32160) SQLLOAD: SQL submitted from loader in is: INSERT INTO "CNCS_APP_TEAM"."RS" ("NAME", "DESCRIPTION", "NOOFSEATS", "NOOFSPECIALSEATS", "ISNETJETS", "RANK", "ISRELEASABLE") VALUES ( :AL_AfterVariable0, :AL_AfterVariable1, :AL_AfterVariable2, :AL_AfterVariable3, :AL_AfterVariable4, :AL_AfterVariable5, :AL_AfterVariable6) . (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) ROW: Transform is importing EOS row <>. (14.2) 03-30-15 17:19:37 (30176:32160) TRAN: Transform is completed. (14.2) 03-30-15 17:19:37 (30176:44564) TRAN: Transform is completed. (14.2) 03-30-15 17:19:37 (30176:19856) TRAN: Transform is completed. (14.2) 03-30-15 17:19:37 (30176:16236) TRAN: Transform is completed. (14.2) 03-30-15 17:19:37 (30176:44956) DATAFLOW: Data flow is completed successfully. (14.2) 03-30-15 17:19:37 (30176:44956) DATAFLOW: Process to execute data flow is completed. (14.2) 03-30-15 17:19:41 (15212:42916) JOB: **DEBUG**:Dataflow releasing <0>MB, Memory in use after release <0>MB, #Dataflows running after release <0> (14.2) 03-30-15 17:19:41 (15212:42916) JOB: Job is completed successfully. (14.2) 03-30-15 17:19:41 (15212:42916) REPO: Saving object in the repository. The SQL generated is: .