DSXchange

Hi Guys, Can you guys please clarify my doubt on Oracle to_number function equivalent in Datastage. I have a inputfield varchar(10) and output oracle filed is Number. In oracle we will give to_number(fieda).I know in Datastage we will move directly from varchar to numeric without any conversion. Ple...

Hi Guys, While i am running my job suddenly today we got this message and job aborts after writing some records,can you guys please help me out. DataStage Job 696 Phantom 3924 Program "JOB.1904744032.DT.1394070058.TRANS1": Line 42, Exception raised in GCI subroutine: Access violation. Atte...

Hi Guys, My requirement is like this: We are using partitioned (year) and subpartitioned(month) oracle target table.we are going to refresh this table daily 4,5 times so as per requirement i have to truncate the subpartitioned (current month )and then load the data in that subpartition. Here is my r...

Ray,

Can you please elaborate how to do it in datastage.

Can you please help me on how to implement Oracle partitioning method using Datastage job.

Thanks in advance.

Reddy

Hi Guys,

We have a Oracle Table Patitioned by year column and Sub-Partitioned by Month column.How can i improve the performance of Datastage jobs using Oracle Patition table means how can i design the Datastage jobs by using Oracle Partition column and Sub-Partition Column.


Thanks in advance
Reddy

Hi Andrew,

just for few days i don't want to run the particular job, i need that job from monday onwards.

I have an idea, why don't i change the job execution action from run to
validate only.

Can you please make sure is this correct or not.

Thanks
Reddy

Hi Guys,

I have a Job sequence running daily with 10 jobs but from tomorrow onwards i need to stop running one of the job in this job sequence.

How do i make one of the job as non runnable state.

Thanks in advance.

Reddy

Naveen, Sorry for confusing you guys. Here i am giving details of my requirement: Currently i am sending a sequential file with 20 columns to the client,client ask me to add header as a first record with filecreation date field(only one column) and trailer as a last record with no.of output records ...

Hi Guys,

Good morning.Are you guys ready for Superbowl party

I would like to combine header record as my first record and trailer as my last record to my detail file.

How can i merge all 3 files one by one means header,detail and trailer.

Have a nice weekend.

Thanks in advance

Reddy

Hi Guys,

Here is my detailed requirement:

I want to schedule jobs for every 2 hours on Business week days.How can you schedule jobs using datastage director scheduler only for Business week days.Here we don't have autosys.

Thanks
Narasa

Hi Gurus,

we want to schedule a job to run every 2 hours during business hours over the weekdays using datastage scheduler.I know we can't run using datastage scheduler.
we don't have third party tools like autosys here.
Is there any alternatives......

Thanks in advance.

Reddy

Use the same column twice except rename it. Hi Kim, Thanks for reply.I linked source filed with 2 lookup cols but i couldn't get any matchings. Here i am attching UV stage user defined query: SELECT narasalow2.col1, narasalow2.col2, narasalow2.col3 FROM "narasalow2" WHERE (narasalow2.col1...

Hi,

Thanks for reply.

I couldn't understand your explanation.please elaborate it.

I made 2 keys for lookup file (UV) as low and high fileds.

I have one Source key filed.

How can do linking on Source key filed against 2 lookup key fileds.

Thansk
Reddy

Do it with Constarint on key filed like Not[isnull(keyfield)] so it can not capture existing ones.

Thanks
Reddy

Good Morning DataStage Gurus, I have a requirement like this: Source file : 2 cols Number,Address Lookup file: 3 cols Low Number,High Number,Value I want to do lookup for Number in between Low number and High Number like 450 in between 1 and 500 and get the value from lookup table. What i did is : I...