Search found 36 matches
- Wed Oct 12, 2016 3:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: rownum for a record
- Replies: 6
- Views: 4003
Re: rownum for a record
hi Do you mean to say you have a rownum column in a sequential file and you wanted to take the first 10 records from the file..if so you can specify head -10 {FileName.txt} ..It will fetch you the first 10 records..However if you dont have a rownum column and wanted to take the first 10 rows from th...
- Thu Sep 22, 2016 2:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Timestamp Issue
- Replies: 3
- Views: 2730
Re: Time stamp Issue
Hi
Use the stage variable in order to do the following logic
Stage var1: To get the date field alone ...Use the field function and get the first field ( by default field has got space as delimiter)
Stage var1: Hard code to 00:00:00
Concatenate the two stage variable
Regards
Naveen
Use the stage variable in order to do the following logic
Stage var1: To get the date field alone ...Use the field function and get the first field ( by default field has got space as delimiter)
Stage var1: Hard code to 00:00:00
Concatenate the two stage variable
Regards
Naveen
- Wed Mar 02, 2016 9:10 pm
- Forum: IBM QualityStage
- Topic: Error occurred in the script - undefined or null reference
- Replies: 1
- Views: 4926
Error occurred in the script - undefined or null reference
Hi all, We are using Data Rules stage , after binding the variable from the input when you click on the Binding variable in the right hand pane in the Data Rules Stage. We are getting a error like a window pop up saying "An error has occurred in the script of this page" Line:219 Char:8 Err...
- Wed Feb 24, 2016 1:34 am
- Forum: General
- Topic: How to concatenate two parameter and pass as Invocation Id
- Replies: 2
- Views: 2676
Re: How to concatenate two parameter and pass as Invocation
Hi , Yes you are correct you will not have the invocation id in the display part of the director, however you can find it in the " Summary of sequence " in the director log. Moreover in your jobactivity when you call the invocation id as 'jobactivity1.jobname' it include the invocation id ...
- Sun Feb 14, 2016 8:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Logic required for If / then / else in tranformer
- Replies: 8
- Views: 5949
Re: Logic required for IF and else in tranformer
Code: Select all
IF isnotNull(FROM_ACCT_NUM)
then right(FROM_ACCT_NUM,2)
else if
isnotNull(FROM_ACCT_NUM)
then right(FROM_ACCT_NUM,2):'XXXXX'
else if
isnotNull(FROM_ACCT_NUM)
then left((right(FROM_ACCT_NUM,2):'XXXXX'):FROM_ACCT_NUM,12) ELSE
FROM_ACCT_NUM
- Fri Feb 05, 2016 12:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Split a source file into multiple files dynamically
- Replies: 6
- Views: 7195
Re: Split a source file into multiple files dynamically
Hi,
This can be performed using schema files in datastage.
Create the schema file for the target as per your requirement.
Regards
Naveen
This can be performed using schema files in datastage.
Create the schema file for the target as per your requirement.
Regards
Naveen
- Mon Jan 18, 2016 2:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SCD stage keep adding unchanged records into table
- Replies: 6
- Views: 3983
Re: SCD stage keep adding unchanged records into table
hi Abyss,
you can do the SCD with the Change Data Capture,chksum and column export stages.
However before that can you please elaborate on whats your problem ?
With the post that you have given , we could not infer what is wrong ?
Regards
Naveen
you can do the SCD with the Change Data Capture,chksum and column export stages.
However before that can you please elaborate on whats your problem ?
With the post that you have given , we could not infer what is wrong ?
Regards
Naveen
- Thu Jan 14, 2016 8:09 pm
- Forum: General
- Topic: re-run the activities in sequence
- Replies: 7
- Views: 4529
- Thu Jan 14, 2016 7:56 pm
- Forum: General
- Topic: Unable to run the datastage jobs
- Replies: 2
- Views: 2583
Re: Unable to run the datastage jobs
hi ,
you have to be more specific on whats happening.
What do you mean by when you are trying to run the job, are you speaking about you clicked the run button and it does nothing? Is that what you mean ..btw ..did you try to execute it through dsjob command ???
Regards
Naveen
you have to be more specific on whats happening.
What do you mean by when you are trying to run the job, are you speaking about you clicked the run button and it does nothing? Is that what you mean ..btw ..did you try to execute it through dsjob command ???
Regards
Naveen
- Thu Jan 07, 2016 8:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate sequence number for the same group
- Replies: 4
- Views: 6063
Re: Generate sequence number for the same group
Hi,
Yes its working.
I hope the one who created this thread can look upon the above solution to fix his problem
Thanks
Regards
Naveen
Yes its working.
I hope the one who created this thread can look upon the above solution to fix his problem
Thanks
Regards
Naveen
- Thu Jan 07, 2016 3:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Generate sequence number for the same group
- Replies: 4
- Views: 6063
Re: Generate sequence number for the same group
Hi you have to use stage variable in the transfomer to get this done.Which I think is the easiest way to perform(though !!! there are lot of ways) In the transformer have 4 stage variable Assign a stage variable 1 = cntvariable as 0 prevrec=currentrecord currentrecord={ the input from the source} Sa...
- Wed Jan 06, 2016 9:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: selecting one record out of 2 records
- Replies: 16
- Views: 12165
I have concatenated as mentioned below Start,End,Start_End,End_Start,Distance Bangalore,Mumbai,BangaloreMumbai,MumbaiBangalore,1500 Hyderabad,Delhi,HyderabadDelhi,DelhiHyderabad,2000 Delhi,Hyderabad,DelhiHyderabad,HyderabadDelhi,2000 Mumbai,Bangalore,MumbaiBangalore,BangaloreMumbai,1500 How to use ...
- Wed Jan 06, 2016 9:45 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: selecting one record out of 2 records
- Replies: 16
- Views: 12165
Anybody help on how to proceed? Hi, Step1: First sort the rows where you wanted to check with Example : a b 100 b a 200 After you sort the above records it would be like the below: a b 100 a b 200 Use the remove duplicate stage to get either the first record or the second records.(Keep those 2 colu...
- Mon Jan 04, 2016 1:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: File pattern was specified this indicates the pattern
- Replies: 7
- Views: 9083
Re: File pattern was specified this indicates the pattern
hi
I tried with the unix environment, I could not find this issue.
However not sure with the windows environment.
probably my turn around would be concatenate all the files into a single file using before job sub routine.
Many Thanks
Regards
Naveen
I tried with the unix environment, I could not find this issue.
However not sure with the windows environment.
probably my turn around would be concatenate all the files into a single file using before job sub routine.
Many Thanks
Regards
Naveen
- Sun Jan 03, 2016 9:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to continue to increment a number
- Replies: 3
- Views: 3570
Re: How to continue to increment a number
Hi If you have a database , then you can place a column as count and load the highest record count in the table and then read the column with max count +1 ..or if you dont have a database create a file and the load the max count value in it along with a dummy join column(name it as 1) .use a join st...