{"id":11432,"date":"2017-09-18T14:38:56","date_gmt":"2017-09-18T18:38:56","guid":{"rendered":"http:\/\/www.iri.com\/blog\/?p=11432"},"modified":"2024-10-23T15:29:17","modified_gmt":"2024-10-23T19:29:17","slug":"using-the-job-script-editor-in-iri-workbench","status":"publish","type":"post","link":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/","title":{"rendered":"The Job Script Editor in IRI Workbench"},"content":{"rendered":"<p class=\"c2\">The\u00a0<span class=\"c9\"><a class=\"c11\" href=\"https:\/\/www.google.com\/url?q=http:\/\/www.iri.com\/products\/workbench&amp;sa=D&amp;ust=1505762139876000&amp;usg=AFQjCNEYqoOus94sK8Zqg2nEeUgBHThktg\">IRI Workbench<\/a><\/span>\u00a0GUI, built on Eclipse\u2122,<span class=\"c0\">\u00a0provides several ways to create data-driven jobs &#8230; jobs which are ultimately expressed in self-documenting plain-text scripts and metadata files. These scripts are saved in projects, and open in a color-coded, syntax-aware editor.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">The editor interacts directly with other graphical facilities in Workbench. These include a job outline, section-specific dialogs, transform mapping diagrams, external metadata formats, and other Eclipse features.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">The &#8220;SCL editor&#8221; is one of several available to users. IRI Workbench is designed to simplify and extend the generation and management of jobs that are created in any IRI product compatible with the IRI Sort Control Language (<a href=\"http:\/\/www.iri.com\/products\/cosort\/sortcl\">SortCL<\/a> or SCL), including:<\/span><\/p>\n<ul class=\"c7 lst-kix_e41ngo271t1v-0 start\">\n<li class=\"c2 c4\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/products\/cosort\">IRI CoSort<\/a> &#8211; sorting, transformation, and reporting<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/products\/nexftform\">IRI NextForm<\/a> &#8211; data and database migration and replication<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/products\/fieldshield\">IRI FieldShield<\/a> &#8211; static data masking in file and ODBC sources<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/products\/rowgen\">IRI RowGen<\/a> &#8211; test data generation into DB, file or report targets<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/products\/voracity\">IRI Voracity<\/a> &#8211; all of the above, plus ETL, subsetting, DQ, CDC, etc.<\/span><\/li>\n<\/ul>\n<p>In this article, I will open jobs in the &#8220;SCL Editor&#8221; and explain some of its features.<\/p>\n<h2 class=\"c2\"><span class=\"c8 c1\">Open the Editor<\/span><\/h2>\n<p class=\"c2\">To open a job in the editor, right-click on any file with a .?cl or .ddf extension in a project folder and click\u00a0<strong>Open with\u00a0&gt;\u00a0SCL Text Editor<\/strong>. The editor view normally opens in the center of Workbench between the\u00a0<strong><span class=\"c1\">Project Explorer<\/span><\/strong>\u00a0and the\u00a0<strong><span class=\"c1\">Outline<\/span><\/strong><span class=\"c0\">.<\/span><\/p>\n<p class=\"c2\">When a job or metadata script is open in the editor, the\u00a0<span class=\"c1\">Outline\u00a0<\/span>view will graphically\u00a0<span class=\"c0\">represent and dynamically interact with the script as you make changes to it. If the Outline view does not display, click <strong>Window &gt; Show View &gt; Outline<\/strong>.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">The editor window is also used for other editors, including standard text editors, the fit-for-purpose IRI FACT and DDF editors, SQL, JSON and XML editors, etc. You can open multiple files simultaneously in that view, with a named tab for each file.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">For example, see the Workbench screenshot below. Three tabs are open in the editor window:<\/span><\/p>\n<ul class=\"c7 lst-kix_yupf572ppk76-0 start\">\n<li class=\"c2 c4\"><span class=\"c0\">RealData.ddf<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\">RealData<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\">SortChiefs.scl<\/span><\/li>\n<\/ul>\n<p class=\"c2\"><span class=\"c0\">By hovering over a tab, you can see the project and name for each file. SortChiefs.scl is in the Chiefs project. Each tab also has an icon before the file name to indicate the file type. <\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">The file RealData.ddf has a blue pelican indicating that the file is a metadata file. The file RealData has an icon that looks like a sheet of paper indicating a text file. The icon for the file SortChiefs.scl is a red pelican. The red pelican indicates that the file is an IRI job script.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">An asterisk (*) immediately before the file name (as with the tab SortChiefs.scl) means that changes to that file have not been saved.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\"><a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-11433\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\" alt=\"\" width=\"500\" height=\"355\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png 943w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1-300x213.png 300w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1-768x546.png 768w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/a><\/span><\/p>\n<p>There is a button after the last tab with the label <strong>&gt;&gt;<sub>3<\/sub><\/strong>. This indicates that there are 3\u00a0<span class=\"c18\">more\u00a0<\/span><span class=\"c0\">files open in the editor window. Click that button to see a list of names for all open files for the editor. The first 3 file names are in bold because there was no room for these files to have tabs.\u00a0<\/span>The next 3 file names are for the files that have a tab in the editor window. Click on any file name to view it in the editor window.<\/p>\n<p><span class=\"c0\"> <a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11434\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-2.png\" alt=\"\" width=\"126\" height=\"157\" \/><\/a><\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">The tab for SortChiefs.scl is the active tab and is using the SCL editor. Its default color scheme (which you can change) is as follows:<\/span><\/p>\n<ul class=\"c7 lst-kix_s1wz8uoqf1gv-0 start\">\n<li class=\"c2 c4\">Reserved words in scripts are\u00a0<span class=\"c5\" style=\"color: red;\">red<\/span>.<\/li>\n<li class=\"c2 c4\">Quoted parameters are\u00a0<span class=\"c23\" style=\"color: blue;\">blue<\/span>.<\/li>\n<li class=\"c2 c4\">Comments are\u00a0<span class=\"c22\" style=\"color: green;\">green<\/span>.<\/li>\n<li class=\"c2 c4\"><span class=\"c0\">Everything else is normal black text.<\/span><\/li>\n<\/ul>\n<p class=\"c2\"><span class=\"c0\">You can edit the file by typing in changes or adding additional lines. The SCL editor is aware of what is valid syntax for job scripts; it displays a white x inside a red circle before any line with invalid syntax. The incorrect line below is missing a slash (\/) before the key word PROCESS:<\/span><\/p>\n<p><span class=\"c0\"> <a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-3.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11435\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-3.png\" alt=\"\" width=\"414\" height=\"47\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-3.png 414w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-3-300x34.png 300w\" sizes=\"(max-width: 414px) 100vw, 414px\" \/><\/a><\/span><\/p>\n<h2 class=\"c2\"><span class=\"c8 c1\">In-Editor Menus<\/span><\/h2>\n<p class=\"c2\">If you right click inside the SCL editor, these menus will appear:<\/p>\n<p><span class=\"c0\"> <a href=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-11436\" src=\"http:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-4.png\" alt=\"\" width=\"624\" height=\"467\" srcset=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-4.png 624w, https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-4-300x225.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/a><\/span><\/p>\n<p class=\"c2\">The first menu has some of the normal editing options like<strong>\u00a0<span class=\"c1\">save<\/span><\/strong>,\u00a0<strong><span class=\"c1\">cut<\/span><\/strong>,\u00a0<strong><span class=\"c1\">copy<\/span><\/strong>, and\u00a0<strong><span class=\"c1\">paste<\/span><\/strong>. If you click on\u00a0<strong><span class=\"c1\">Source<\/span><\/strong>, the\u00a0<strong><span class=\"c1\">Toggle Comment<\/span><\/strong>\u00a0is useful. To apply this, highlight lines in the script, and then click on\u00a0<strong><span class=\"c1\">Toggle Comment<\/span><\/strong><span class=\"c0\">. <\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">Each of the highlighted lines will have a number sign (#) placed at the beginning of the line to indicate that the line is a comment and not an active line for the script. Repeat the process to remove the #.<\/span><\/p>\n<p class=\"c2\">If you click on\u00a0<strong><span class=\"c1\">IRI,<\/span><\/strong><span class=\"c1\">\u00a0<\/span><span class=\"c0\">the next menu has three groups of options:<\/span><\/p>\n<ol class=\"c7 lst-kix_jhdzhleqotto-0 start\" start=\"1\">\n<li class=\"c2 c4\"><span class=\"c0\">Items in the first group take you to specific wizards that edit or add to the existing script.<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\">The second group creates special files from the script.<\/span><\/li>\n<li class=\"c2 c4\"><span class=\"c0\">The third initiates some special procedures for the script<\/span><\/li>\n<\/ol>\n<p class=\"c2\">A right-click on -&gt;\u00a0<strong><span class=\"c1\">IRI<\/span>\u00a0<\/strong>-&gt;\u00a0<strong><span class=\"c1\">CoSort <\/span><\/strong><span class=\"c1\">shows\u00a0<\/span><span class=\"c0\">menu options to:<\/span><\/p>\n<ul class=\"c7 lst-kix_v3n56uw5t4af-0 start\">\n<li class=\"c2 c4\"><strong><span class=\"c1\">Edit Job Controls<\/span><\/strong><span class=\"c0\">: set controls at the top of the script that apply to the whole job<\/span><\/li>\n<li class=\"c2 c4\"><strong><span class=\"c1\">Add\/Replace\u00a0<\/span><\/strong><span class=\"c0\">an action; i.e., create or replace a sort, join, or merge definition.<\/span><\/li>\n<\/ul>\n<h2 class=\"c2\"><span class=\"c1 c8\">Run Your Job from the Editor<\/span><\/h2>\n<p class=\"c2\"><span class=\"c0\">Run the active job script by selecting one of two menu options:<\/span><\/p>\n<ul class=\"c7 lst-kix_hoi5teeruq9t-0 start\">\n<li class=\"c2 c4\"><strong><span class=\"c1\">Run As<\/span><\/strong>\u00a0-&gt;\u00a0<strong><span class=\"c1\">IRI Job<\/span><\/strong>: This will execute the job and then display something similar to the following in the\u00a0<strong><span class=\"c1\">Console<\/span><\/strong>.<\/li>\n<\/ul>\n<p><code>C:\\IRI\\CoSort95\\bin\\sortcl \/spec=SortChiefs.scl<\/code><\/p>\n<p>Time taken 0.0 seconds<\/p>\n<ul class=\"c7 lst-kix_hoi5teeruq9t-0\">\n<li class=\"c2 c4\"><strong><span class=\"c1\">Debug As<\/span><\/strong>\u00a0-&gt;\u00a0<strong><span class=\"c1\">IRI Job<\/span><\/strong>: This will execute the job and then display the contents of the Cosort Error Log (.cserrlog) in the\u00a0<strong><span class=\"c1\">Console<\/span><\/strong><span class=\"c0\"><strong>\u00a0<\/strong>when the job completes. This gives detailed information from the run.<\/span><\/li>\n<\/ul>\n<p class=\"c2\">If an error is encountered by either method during the execution, a popup named<strong>\u00a0<span class=\"c1\">Problem Occurred<\/span><\/strong>\u00a0will display the error. If you run with\u00a0<strong><span class=\"c1\">Debug As<\/span><\/strong><span class=\"c0\">, it is possible to get more information concerning the error.<\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">Now we know that there is a context-sensitive SCL editor in IRI Workbench for working directly with job scripts and DDF files. These same files could be created from wizards or diagrams, and then edited in the SCL editor (or vice versa). <\/span><\/p>\n<p class=\"c2\"><span class=\"c0\">Once your job scripts are complete, save and run them from the editor or using other options in the Eclipse GUI. You can even work with the same scripts in other text editors, and run them from the command line.<\/span><\/p>\n<p class=\"c2\">Email\u00a0<span class=\"c9\"><a class=\"c11\" href=\"mailto:support@iri.com\">support@iri.com<\/a><\/span>\u00a0for help with the script editor, or other job design methods in IRI Workbench.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The\u00a0IRI Workbench\u00a0GUI, built on Eclipse\u2122,\u00a0provides several ways to create data-driven jobs &#8230; jobs which are ultimately expressed in self-documenting plain-text scripts and metadata files. These scripts are saved in projects, and open in a color-coded, syntax-aware editor. The editor interacts directly with other graphical facilities in Workbench. These include a job outline, section-specific dialogs, transform<\/p>\n<div><a class=\"btn-filled btn\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\" title=\"The Job Script Editor in IRI Workbench\">Read More<\/a><\/div>\n","protected":false},"author":10,"featured_media":11433,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"footnotes":""},"categories":[32,8,31,363,1,776,91,233,29],"tags":[],"class_list":["post-11432","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-business-intelligence","category-data-protection","category-data-migration","category-data-quality","category-data-transformation2","category-etl","category-iri-workbench","category-metadata-management","category-test-data"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v23.4 (Yoast SEO v23.4) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>The Job Script Editor in IRI Workbench - IRI<\/title>\n<meta name=\"description\" content=\"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The Job Script Editor in IRI Workbench\" \/>\n<meta property=\"og:description\" content=\"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\" \/>\n<meta property=\"og:site_name\" content=\"IRI\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-18T18:38:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-23T19:29:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"943\" \/>\n\t<meta property=\"og:image:height\" content=\"670\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Susan Gegner\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Susan Gegner\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\"},\"author\":{\"name\":\"Susan Gegner\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\"},\"headline\":\"The Job Script Editor in IRI Workbench\",\"datePublished\":\"2017-09-18T18:38:56+00:00\",\"dateModified\":\"2024-10-23T19:29:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\"},\"wordCount\":1042,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\",\"articleSection\":[\"Business Intelligence (BI&#041;\",\"Data Masking\/Protection\",\"Data Migration\",\"Data Quality (DQ&#041;\",\"Data Transformation\",\"ETL\",\"IRI Workbench\",\"Metadata Management\",\"Test Data\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\",\"url\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\",\"name\":\"The Job Script Editor in IRI Workbench - IRI\",\"isPartOf\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\",\"datePublished\":\"2017-09-18T18:38:56+00:00\",\"dateModified\":\"2024-10-23T19:29:17+00:00\",\"description\":\"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png\",\"width\":943,\"height\":670},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.iri.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The Job Script Editor in IRI Workbench\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.iri.com\/blog\/#website\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"name\":\"IRI\",\"description\":\"Total Data Management Blog\",\"publisher\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.iri.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.iri.com\/blog\/#organization\",\"name\":\"IRI\",\"url\":\"https:\/\/www.iri.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"contentUrl\":\"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png\",\"width\":750,\"height\":206,\"caption\":\"IRI\"},\"image\":{\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63\",\"name\":\"Susan Gegner\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g\",\"caption\":\"Susan Gegner\"},\"url\":\"https:\/\/www.iri.com\/blog\/author\/susang\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The Job Script Editor in IRI Workbench - IRI","description":"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/","og_locale":"en_US","og_type":"article","og_title":"The Job Script Editor in IRI Workbench","og_description":"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.","og_url":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/","og_site_name":"IRI","article_published_time":"2017-09-18T18:38:56+00:00","article_modified_time":"2024-10-23T19:29:17+00:00","og_image":[{"width":943,"height":670,"url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","type":"image\/png"}],"author":"Susan Gegner","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Susan Gegner","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#article","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/"},"author":{"name":"Susan Gegner","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63"},"headline":"The Job Script Editor in IRI Workbench","datePublished":"2017-09-18T18:38:56+00:00","dateModified":"2024-10-23T19:29:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/"},"wordCount":1042,"commentCount":1,"publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","articleSection":["Business Intelligence (BI&#041;","Data Masking\/Protection","Data Migration","Data Quality (DQ&#041;","Data Transformation","ETL","IRI Workbench","Metadata Management","Test Data"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/","url":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/","name":"The Job Script Editor in IRI Workbench - IRI","isPartOf":{"@id":"https:\/\/www.iri.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage"},"image":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage"},"thumbnailUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","datePublished":"2017-09-18T18:38:56+00:00","dateModified":"2024-10-23T19:29:17+00:00","description":"Learn how the script editor in IRI Workbench can simplify creation and management of your SortCL jobs and data definition (metadata) files.","breadcrumb":{"@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#primaryimage","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","width":943,"height":670},{"@type":"BreadcrumbList","@id":"https:\/\/www.iri.com\/blog\/data-transformation2\/using-the-job-script-editor-in-iri-workbench\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.iri.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The Job Script Editor in IRI Workbench"}]},{"@type":"WebSite","@id":"https:\/\/www.iri.com\/blog\/#website","url":"https:\/\/www.iri.com\/blog\/","name":"IRI","description":"Total Data Management Blog","publisher":{"@id":"https:\/\/www.iri.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.iri.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.iri.com\/blog\/#organization","name":"IRI","url":"https:\/\/www.iri.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","contentUrl":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2019\/02\/iri-logo-total-data-management-small-1.png","width":750,"height":206,"caption":"IRI"},"image":{"@id":"https:\/\/www.iri.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/87be5da567628ab9396ca81170f36d63","name":"Susan Gegner","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.iri.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2b1ca5592a65d44483351292cf1ae00a?s=96&d=blank&r=g","caption":"Susan Gegner"},"url":"https:\/\/www.iri.com\/blog\/author\/susang\/"}]}},"jetpack_featured_media_url":"https:\/\/www.iri.com\/blog\/wp-content\/uploads\/2017\/09\/scl-editor-image-1.png","_links":{"self":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11432"}],"collection":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/comments?post=11432"}],"version-history":[{"count":15,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11432\/revisions"}],"predecessor-version":[{"id":18068,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/posts\/11432\/revisions\/18068"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media\/11433"}],"wp:attachment":[{"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/media?parent=11432"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/categories?post=11432"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.iri.com\/blog\/wp-json\/wp\/v2\/tags?post=11432"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}