Search found 592 matches
- Thu Oct 04, 2007 6:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: sequence
- Replies: 1
- Views: 1097
- 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]')
- 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...
- 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
- 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:
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'
- 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...
- 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.
- 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
- 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...
- Thu Sep 27, 2007 6:17 pm
- Forum: General
- Topic: take long time to load up Director
- Replies: 6
- Views: 2651
- Thu Sep 27, 2007 7:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Quoted Strings as Parameter
- Replies: 12
- Views: 4962
- 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
- Thu Sep 27, 2007 2:58 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datetime field overflow
- Replies: 3
- Views: 2343
- 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
- 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...