DSXchange

Hi All, I have a scenario the pull out the records in folllowing order. For a particular student there will be many records. there is a code column. if the code is 1 pull put all the 1 records, else if code is 2 pull out all the 2 records else pull out all the 3 records Please can anyone help me wit...

Hi

I'm getting following error while loading from a sequential file.
I'm converting a column from string to date

DB2_TABLE1,0: Invalid date value in getInputFieldAsDate() for field '4' of input dataset '0'.

Please can anybody help me

The Tables are getting loaded. But still the warnings exists.

Hi I have a dataset and i'm loading the records from transformer to a db2 table dataset---->Transformer-------->Db2Table. The table is in Clear and Insert Mode When the table is empty, the records are loading correctlt. When there is record it gives the warning Table1,0: Warning: JobLoad: SQLExecDir...

Hi

Can any give the command to export multiple jobs and append into a single dsx using command edtor

Hi

Where can i find the osh file for a give job. Is the OSH file is in the Unix shell or it is a BASIC Code or it is OOPS Code. How does it gets created during compilation

yes the search is based on the Job name

Hi

I'm using DSEE. IN this we hae many stages

We have sort stage which has remove duplicate option and in the Remove Duplicate stage we have sort option.
Which is best and when should we use each. Also we can do sort explicitily and remove duplicate then

Thanks and Regards
Arun

HI

I want to search a job existing in a project or not
How to search a job

Hi

I need to run a job for 12 times. Each time it should pass the run as a parameter to the month.

Here no unix scripts shuld be used nor any server job.

Is there by any chance can we implement it in Parallel job?


Thanks in Advance

Hi
I'm getting the wraming as mentioned below

LKP_DenormLICS_ACL,0: Ignoring duplicate entry at table record 9; no further warnings will be issued for this table

How to avoid this warning

Hi

I'm getting an warnings in the Lookup Stage


"When checking operator: Dropping component "DATEFIELD" because of a prior component with the same name."

Can anyone give suggestions to overcome this warnings

Hi All

What is the difference in sorting using a sort stage and sorting done inside a stages like Remove duplicate Joins etc...

Why do we have sort there when we have an explict sort stage ?

Which is more effective ?

Hi I'm using datastage 7.5.2 edition. I need to find difference between two dates. when i gave date1-date2 the error is Error in Stage Variable derivation expression for variable DateDiff. Invalid conversion requested from a date to a dfloat. Please can any one help on this. Thanks and Regards Arun ...

Hi

I need to capture file created timestamp and need to process in the job. how to get the file information

Thanks and regards
Arun