Inside the folder, you will see, Sequence Job and four parallel jobs. Step 6 To see the sequence job. It will show the workflow of the four parallel jobs that the job sequence controls. Step 7 To see the parallel jobs. It will open window as shown below. It contains the CCD tables. In DataStage, you use data connection objects with related connector stages to quickly define a connection to a data source in a job design.
Use following commands. Step 6 In the next window save data connection. Step 3 Click load on connection detail page. This will populate the wizard fields with connection information from the data connection that you created in the previous chapter. Step 4 Click Test connection on the same page. Click Next.
Step 5 Make sure on the Data source location page the Hostname and Database name fields are correctly populated. Then click next. Step 6 On Schema page. The selection page will show the list of tables that are defined in the ASN Schema.
It has the detail about the synchronization points that allows DataStage to keep track of which rows it has fetched from the CCD tables. Click import and then in the open window click open. You need to modify the stages to add connection information and link to dataset files that DataStage populates. Stages have predefined properties that are editable. Step 1 Browse the Designer repository tree. To edit, right-click the job. The design window of the parallel job opens in the Designer Palette.
Step 2 Locate the green icon. This icon signifies the DB2 connector stage. It is used for extracting data from the CCD table. Double-click the icon. A stage editor window opens. Step 3 In the editor click Load to populate the fields with connection information. To close the stage editor and save your changes click OK.
Locate the icon for the getSynchPoints DB2 connector stage. Then double-click the icon. Step 5 Now click load button to populate the fields with connection information. Then select the option to load the connection information for the getSynchPoints stage, which interacts with the control tables rather than the CCD table.
Hi We have folder stage in px. Dear All, Can any one please tell me how to call multiple file in the sequential file stage in the parallel job. Thanks in advance. Register or Login. Welcome back! Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests.
Wild card in seq file 2. Generic file to table load dsjob- use RCP and a schema file. If schema is same only file names are different — you can use field names instead of RCP. Other option is to have a command stage in job seq which reads file name n passes parameters to seq file and the db stage.
No Account? Sign up. By signing in, you agree to our Terms of Use and Privacy Policy. Already have an account? Sign in. By signing up, you agree to our Terms of Use and Privacy Policy.
Enter the email address associated with your account. We'll send a magic link to your inbox. Email Address. All Sign in options. Enter a Email Address. Choose your interests Get the latest news, expert insights and market research, sent straight to your inbox. DSXchange A short text to describe your forum Skip to content. Quick links. Usage of folder stage Post by userds » Sat Mar 12, pm Requirement: I am having collection of files in a folder.
I need to read all the files and depending on the filename i need to call corrosponding datastage job. Please let me know how to implement this requirement using folder Stage. The first two charecters represents Feed type and 4th to 7th charecter represents Feed no. So, based on the Feed type and Feed no i have to call a purticular job.
Please give me some idea to implement this requirement, like which source stage, processing Stage and output stage i can use to implement this requirement.
0コメント