DSXchange

Hi , I am facing problems in folder stage when I am parsing xml into sequential files 1- When there is no file to pick up from the directory path specified the also the job runs and creates sequential files with the metadata , I there a WAY TO Sstop this from happening 2- eVEN IF THE JOB ABORTS FIIL...

Hi Sunil This routine might help you I haven't tested it yet * ----------------------------------------------------------------- * KgdCreateBcpMetadata(DsMetadataId) * Decription: Create Bcp file from records in DS_METADATA. * Written by: Kim Duke * Notes: * -----------------------------------------...

I wanted to know how can we call and populate the input files mentioned in the folder stage in a subroutine and also is there a way to generate surrogate key ( each time the subroutine is run we can populate a unique key in the output )

I need help in knowing how to get the filename we are using in the folder stage for the use in the routine

I need to know that like if i am giving the column name as item_id as an integer with the length of 20 and as a primary key , Then how can I display it into a sequential file like column name length type key Item_id 20 integer Yes

I need help in knowing how to create a sequential file that will contain the metadata definition of all the columns , like column name , data type , length [/b]