DSXchange

Or probably u can try writing the first field that is name of the file into a file in the same job and use the content of this file in a after job subroutine to the rename the original file (one containing the data) created in the same job.

use string search functions to find if the required string is present in the incoming string.

A drop of records happens for null values mainly when u try to perform some operation on a field and when null comes into this field. The best way would be to let remain the field nullable itself towards the end of the job and then finally just before loading into the database or so, check if the fi...

Why don't you allow the fields to remain nullable. Is there any specific requirement that forces you to use default values for nullable fields. if not then you can probaly handle the null fields towards the end of your job. Also timestamp field '*******' means you are inserting a invalid value into ...

Check the log of the job and see if the records are being dropped or not while writing into sequential file. This can happen when you don't provide a null handling property for a nullable field populated into a sequential file.

Hi,

When i am hardcoding '1' instead of using nextsurrogatekey() in SCD I dont receive compilation error. And also when I am using state file in the same job pointing to a target corresponding state file the job runs successfully.

-Shamail

Hi, Have anyone used DB Sequence to generate Surrogate key in SCD stage. i created a sequence in DB2 using.. CREATE SEQUENCE SEQ_SCDEMP2 AS DECIMAL(4,0) START WITH 1 INCREMENT BY 1 MINVALUE 1 NO MAXVALUE NO CYCLE NO CACHE ORDER Then i called this in SCD stage in the surrogate key tab with the name o...

I am not sure exactly what details those would be and as I said it's purely for knowledge purpose of something I have been wanting to know. Hence whoever knows how the metadata are stored and how they can be acessed in both versions of datastage kindly reply.

Thanks,
- Shamail

Hey Ray thanks... I had always wanted to know about the internal processes of Datastage and I know this is the best place to know about them or find out where I can know about them, where experts like you people reside... :) . Can you please suggest any place where I can find these and if not would ...

Hi All, I have been working in datastage 7.x and am currently moving into 8. I came to know that the metadata is stored in DB2 in Datastage8. Can you please help me in understanding: 1) How is metadata stored in DS 7.x. Is it in DB2 itself or using any other internal database. If so is there any way...