Search found 592 matches

by JoshGeorge
Thu Oct 04, 2007 6:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequence
Replies: 1
Views: 1097

You might want to do this in a Sequence job. Give output link from both jobs with 'OK' trigger (If you want to go forward for 'Finished with warning' you have to add those triggers also) to a sequencer stage with 'ALL' mode.
by JoshGeorge
Thu Oct 04, 2007 3:40 am
Forum: General
Topic: month_end date
Replies: 2
Views: 1896

Code: Select all

OConv((MONTH.FIRST(MONTH.TAG(DATE())) - 1) ,'D-YMD[4,2,2]') 
by JoshGeorge
Thu Oct 04, 2007 3:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare two Output Columns
Replies: 2
Views: 1603

Re: Compare two Output Columns

You don't need an extra stage for this, you can do this in transformer itself. AGG_Output.Count = Datastage.Count :? (Datastage.Count what will be that? ) I am having a Tailer record in which I will have a count of the total file and I need to compare this count with Datastage count from Transformer...
by JoshGeorge
Thu Oct 04, 2007 3:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: copy jobs from one project to another project
Replies: 2
Views: 649

Version control also does an import and export apart from versioning. Have you tried to cut and paste the job design between projects? :wink:
by JoshGeorge
Thu Oct 04, 2007 2:59 am
Forum: General
Topic: Removing Header/Trailer from Seq File
Replies: 7
Views: 9981

If you have MKS Toolkit installed (Which Ships and installs with version 7.5x2) you can try the below described:

To remove header (2) and footer (2) from your file try this command in your filter option of sequential file satge:

Code: Select all

 
sed 'N;$!P;$!D;$d' -e '1d' -e '2d'
by JoshGeorge
Tue Oct 02, 2007 7:05 pm
Forum: General
Topic: Job Sequence trigger usage based on data value 0 or !=0
Replies: 15
Views: 6607

In parallel jobs you don't have the facility to write a value to a variable like server jobs using $userstatus (If you search for 'setuserstatus' you can find more on this). What you can do is: write the value into a file and use an execute command stage to 'cat' this value and according to the retu...
by JoshGeorge
Mon Oct 01, 2007 3:50 am
Forum: Site/Forum
Topic: Metadata Loading at Runtime
Replies: 2
Views: 3432

This LINK might be of interest.
by JoshGeorge
Sat Sep 29, 2007 5:14 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to hiding Password in the joblog
Replies: 4
Views: 1426

You might want to check if the type for $CMDW_DB2_PASSWORD is set as encrypted in the administrator itself.
by JoshGeorge
Fri Sep 28, 2007 7:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environmental variable issue
Replies: 3
Views: 2097

You can give $PROJDEF for encrypted variables also. Just key in $PROJDEF in the encrypted mode for your password variable in the job parameter grid. for remaining all values i am using the $PROJDEF as the values in the sequence. because of password is in encrypted form we can't give hte value to $PR...
by JoshGeorge
Thu Sep 27, 2007 6:17 pm
Forum: General
Topic: take long time to load up Director
Replies: 6
Views: 2651

If you have a lot of job instances piled up director takes time to display them. Also set your refresh interval in the director to a higher interval.
by JoshGeorge
Thu Sep 27, 2007 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Quoted Strings as Parameter
Replies: 12
Views: 4962

Put eval before dsjob (eval dsjob -run -param ) or include the parameter name also into the quote and try.
by JoshGeorge
Thu Sep 27, 2007 3:11 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can we attach Timestamp to a Output File
Replies: 3
Views: 1718

You can either pass the Timestamp as a job parameter and include that in your file name option (#Dir##FileName##TimeStamp#) the sequential file stage or use mv <Dir>/<FileName> <Dir>/<FileName>`date '+%Y-%m-%d:%H:%M:%S'` in the job parameter grid option for after job ExecSH option.
by JoshGeorge
Thu Sep 27, 2007 2:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datetime field overflow
Replies: 3
Views: 2343

Your target database is expecting Timestamp in a different format. You might have to to format it according the expecting format.
by JoshGeorge
Wed Sep 26, 2007 7:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Usage of server components in parallel engine
Replies: 7
Views: 1780

Just to clarify - a hashed file will not be identified in Parallel engine . Shared container part of the code with server components will be execute in server engine.
by JoshGeorge
Wed Sep 26, 2007 6:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job scheduling information from command line
Replies: 1
Views: 1015

Even if you do scheduling through Datastage director in the background a crontab entry is the result. Cron is a Unix/Linux program scheduler. It'll automatically execute commands on your server according to a schedule you specify. You can see the schedule list with crontab -l [username]: List List t...