Search found 243 matches

by gssr
Tue Dec 29, 2009 1:57 am
Forum: General
Topic: Need details about Certification program for DS 7.5x Px
Replies: 1
Views: 935

Need details about Certification program for DS 7.5x Px

Hi all, I am tring to get a certification in DS 7.5.2 Px, I got a dump guide from my ffriend ,but it was an older version which is older than 3 years. I think that dump questions may get updated, So can anyone tell me ,where and how can i get the latest DUMP guide for DS certification? Thanks in adv...
by gssr
Tue Dec 29, 2009 1:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

Do you understand what that first slash means? I suspect not. cd to $DSHOME/bin and then issue your ./dsexport from there. There are no .exe files on UNIX so do not incl ... I tried the steps, 1. cd to $DSHOME/bin 2. /dsexport /H=dstest /U=tuser /P=dstest /JOB=Testjob1 ETL_TEST /home/tuser/job.dsx ...
by gssr
Tue Dec 29, 2009 12:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

Sorry Ray,
i am not able to read your full content,
Do i need to check the root directory?

Actually ,i executed the command in the home dir,

Code: Select all

tuser@dstest:/home/tuser>/dsexport.exe /H=dstest /U=tuser /P=dstest /JOB=Testjob1 ETL_TEST /home/tuser/job.dsx 
Thanks,
by gssr
Mon Dec 28, 2009 11:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

Thankyou all for your thoughts, I tried to execute the below code /dsexport.exe /H=dstest /U=tuser /P=dstest /JOB=Testjob1 ETL_TEST /home/tuser/job.dsx where dstest is the server tuser - > user name dstest - > Password Testjob1 - > name of the job to be exported ETL_TEST - > Project in which the job...
by gssr
Mon Dec 28, 2009 6:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

dsimport.exe /H=<hostname> /U=<user> /P=<password> <project> <path>\job.dsx dsexport.exe /H=<hostname> /U=<user> /P=<password> /JOB=<job> <project> <path>\job.dsx Do i have to execute this command in home directory? I logged into the unixbox AIX through the user/password of that project, Can anyone...
by gssr
Mon Dec 28, 2009 1:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: aggregator question
Replies: 2
Views: 1048

You can do it in a single aggregator stage for all your calculations
by gssr
Mon Dec 28, 2009 1:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can I remove numeric values from a string?
Replies: 4
Views: 2650

In which Version 7x or 8x?
parallel Or Server?
Post in the right forum, so that everyone can understand your requirement.

For Px, you can use functions with Transformer stage.
Go through the online manual of Parjdev to know more about the functions.
by gssr
Mon Dec 28, 2009 12:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup with two values
Replies: 6
Views: 1681

gssr wrote:Hope this wil work,
1.Convert the start and end time to Int datatype (i.e., 1.00-->60 and 1.59 --> 119)
:idea:
Use the function " Minutes FromTime"
by gssr
Mon Dec 28, 2009 12:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: lookup with two values
Replies: 6
Views: 1681

Hope this wil work,
1.Convert the start and end time to Int datatype (i.e., 1.00-->60 and 1.59 --> 119)
Similarly convert the same in your source file.

2. Try to get the matched constraint that lookup with those range of records
:idea:
by gssr
Sun Dec 27, 2009 11:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

chulett wrote:What 7.x version? ...
Yes, V7.5.2 Px

Akumar,
I want to export a specific catagory folder that contains a set of 25 jobs. Can i do it with single command or else i have to export every job with a seperate command ?

Thanks in advance
by gssr
Thu Dec 24, 2009 5:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: TO export job through unix
Replies: 19
Views: 6037

TO export job through unix

Hi,
Do anyone have any idea of exporting and impoting jobs or awhole project through commands in Unix OS
DS server - AIX 5.4

Thanks in advance,
by gssr
Tue Dec 22, 2009 5:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: <_PEEK_IDENT_> Input dataset does not have field:
Replies: 7
Views: 6990

I tried to develop a new job for the same execution and its now running fine,
I still dont know which was the problem that throws the error..
I am going through it..

Thank you all for your comments,
by gssr
Mon Dec 21, 2009 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: <_PEEK_IDENT_> Input dataset does not have field:
Replies: 7
Views: 6990

Other Warnings related to this are..


.

Code: Select all

 When checking operator:The modify operator has a binding for the non-existent output field "sstatus".
When checking operator: The modify operator keeps field "sstatus" which is not present in the output interface
by gssr
Mon Dec 21, 2009 10:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: <_PEEK_IDENT_> Input dataset does not have field:
Replies: 7
Views: 6990

One Input datset is having that field and i am merging with the other dataset..
The Job run finished ok with this warning....

When i try to use the output dataset as input in another job, the same warning came and the job gets aborted....

Any Suggestions....