DSXchange

There is no way in DS to store and import table definition for Sequential file. Want to create an Utility in Visual Basic , so that it can create the metadata structure of Source/Target file from Source to Target mapping document and directly import that metadata definition in DataStage designer. 1....

As sequential file does not store in Table Definition folder, i want to create a utility in VisualStudio , so that it can get the metadata structure from a flat file and create a table definition in DataStage redable format. Question is : Where to (which location ) place this table definition file i...

Is there any architectural difference between DS4.0 and DS7.5 ?

Is there any new stages came with DS7.5 , those are not present in DS4.0 ?

I want to upgrade considerable number of jobs from Version 4.0 to DataStage 7.5. Both are in Server version.

Pls let me know , what will be the easiest way.
Is it possible to import DS 4.0 version job in DS7.5 env. ?

if possible pls provide Architectural difference between DS 4.0 and DS 7.5

chulett wrote:Sounds like you should make your surrogate key columns larger in your tables. How are they defined now? ...

Sure , its a process to overcome this issue. But i want a permanant solution like- it refresh all the surrogate key values , again re-generate it from starting

Using NextkeyGen() to create and insert surrogate key in target table . Jobs are in schedule. But due to regular insert surrogate key value exceeding the column limit . So its not able to insert data in table. What is the process should i use in project to refresh the surrogate key values keeping da...

Please , tell me what are the Stages we have to use to generate Xml Output files from a sequential file.

chulett wrote: Suggestion: Post the actual, unedited, full error. Is it a DataStage message or one from Oracle? ...

F_JDE_FACT,1: Unable to use a record for update.

This is a DataStage message.

When i am trying to delete record from a table in Oracle enterprise stage select Write Method : Delete rows .

It is giving error :Unable to use a record for update.

Please sugest.

I am populating one CHAR(6) filed of a table from another tables Varchar2 filed. But after poulating done when i am trying to fire a query in Oracle with where cond <Column_name>='value' , though value exist in table , yet it showing no record. Reason is that there may be some space etc padded with ...

Krazykoolrohit wrote:

das_nirmalya wrote: 1;$<env_var>/

Is this what you are writing in after-job subroutine? or is it a part of the command?

What does the above do?

yea , i have use this in after-job subroutine.

i want to use environment variable to specify the path, where the job create a log file through afterjob subroutine from job property.

i am using 1;$<env_var>/ as the input parameter in after job subroutine , but it is not working ,, pls tell me how can i fullfill the requirement

if i use a unix shell script as a before job subroune in job property. how can i use output of this unix script in a transformer used in that job.

i.e i want to use the output value for some comparision etc

I have used Routine activity in a sequence and call dsjobreport. But it is not showing details information of all jobs added in the sequence , just giving summary information i.e starttime,endtime etc. But i want to create the report just like job level report , for all jobs in the sequence , i.e se...

We can generate job report from Job property->after run subroutine and can store physically as a file!!!

how can i generate such type of report in Sequence level,,, i.e report for a set of job in a single file