DSXchange

Try to customize you own data element.

Check the permission for the directory C:\Ascential\DataStage\hashfile2, it can be readonly. Else give some other directory with proper file name.

If you look in to the help for Change code, you can understand that each code have different meaning. Copy: both before and after key and values are same.
Delete: If Before key is not present in after key.
Insert : If its a new key came in After records.....

Is it a timestamp or date? You have a option to convert the dates into Julian date. Which is inturns a integer. Now you can add what ever you need and convert it back to required format.

Create a stored procedure and import in the Stored Procedure stage and call it. Else you can call using OCI stage as well. {call sp(input,output)};

Were you able to see the tables when you open the copy book from import wizard?
You can mention the start position from where you need to import, do you get any error when you open the file.
If tables have appeared, have you selected any of the tables before clikcing the Import button?

The condition don't restrict any column, but only rows. You can tell us what are the input columns and what are the output.
You can check the 'Change code' for which the output is obtained.
You should get the output of after records for other than copy.

Before this or after this message, there should be another one with some SQL code in it.
Have you reset your job and looked for "From previou log..." message as suggested?

If I understand your requirement, you need to either reject the rows with deptno=20 or deptno<>20. Give it as a constraints, and mark the other link as reject. If you want to parameterize, the value can be deptno = parameter (without any '#'). If your requirement is different, you can specify it aga...

If you use database stage, you can use last_day() and add_months() function as well.

If you are refering to Length and Display, Length is the actual length defined for that field, and Display is the length you specify for the datastage so show up the number of digit when you do view Data.

Its not mandate to import the Table definition for the job to process. By importing the table definition, you are storing a copy of the layout in the Datastage metadata repository. So you can re use it, and will ease your job to specify the metadata for a large tables.

Hi Vijay,

As mentioned by Craig, you dont required this stage for your given need. Just pick up what ever column you need from the joined input.

In addition to Craig's Question, do answer my question as well. What is the format of field HIREDATE value before getting loaded into database?

You will need to check the delimiter for the file and specify the same in the stage. If there is no Quote found in file, mention the Quote as none (000),