Search found 21 matches
- Tue Jan 24, 2012 12:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to generate the following using data in datastage
- Replies: 6
- Views: 3191
Hi Eric Dodson, Thank you for the reply
Thanks a lot for the reply, but i just want to have the combination of the 1 and zero for the length of 15 and every combination must be unique.for example 100000000000000 000000000000001 000000000000011 000000000001111 and so on. We have to use 1 and 0 only and the length is 15 so 2 power 15=32768 ...
- Mon Jan 23, 2012 7:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to generate the following using data in datastage
- Replies: 6
- Views: 3191
How to generate the following using data in datastage
I have to generate a file with two columns (ID and COMB). ID must contain a sequence number so Integer data type.(I took care of that). COMB column must have the data like this. ( it can be numeric or string) 111111111111111 111111111111110 111111111111100 and so on. The size is 15 and it must have ...
- Tue Dec 20, 2011 2:37 am
- Forum: General
- Topic: Unix command for clearing datastage job logs.
- Replies: 5
- Views: 5851
Unix command for clearing datastage job logs.
I built a script which ckecks the status for all datastage jobs in a project and clears the log if the status of the job is successful. I used the "CLEAR.FILE RT_LOG" $project_name $job_name which is throwing an error as "Unable to clear file RT_LOG." I heard that CLEAR.FILE comm...
- Tue Dec 13, 2011 3:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unix script for clearing the datastage logs
- Replies: 1
- Views: 1417
Unix script for clearing the datastage logs
I want to clear the datastage job log using a unix script
- Mon Dec 12, 2011 10:02 am
- Forum: General
- Topic: Purging logs in Datastage using a UNIX Script
- Replies: 7
- Views: 4170
- Mon Dec 12, 2011 7:20 am
- Forum: General
- Topic: Purging logs in Datastage using a UNIX Script
- Replies: 7
- Views: 4170
- Mon Dec 12, 2011 2:01 am
- Forum: General
- Topic: Purging logs in Datastage using a UNIX Script
- Replies: 7
- Views: 4170
Purging logs in Datastage using a UNIX Script
Need a customized unix script to purge the log in data stage. The only condition is,if it is a successful job then the log must clear for just one day, If it is an aborted job, then the log must be fully cleared.
- Mon Feb 14, 2011 10:35 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parallel routine for reconciliation purpose
- Replies: 10
- Views: 9081
- Sun Feb 13, 2011 9:42 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: parallel routine for reconciliation purpose
- Replies: 10
- Views: 9081
parallel routine for reconciliation purpose
Hi I am working on Datastage V8.1 parallel Jobs. Can anybody please provide me a parallel routine for reconcilitation purpose. The functioality which i need in the routine is It must compare the count of input records from the source link and count of output records to the target link. If both are e...
- Wed Jan 19, 2011 5:54 am
- Forum: General
- Topic: How to capture the return value from a routine
- Replies: 2
- Views: 2926
How to capture the return value from a routine
I have a server routine which is using in a job sequence, I want to capture the return value from the routine and save it in a textfile. ReconLinkCount(jobname,stagename,linkname) #include DSINCLUDE JOBCONTROL.H Ans = 0 ThisJob = jobname ThisStage = stagename ThisLink = linkname JobHandle = DSAttach...
- Tue Jan 18, 2011 5:16 am
- Forum: General
- Topic: Routine for getting the count in the link
- Replies: 5
- Views: 2869
- Tue Jan 18, 2011 12:04 am
- Forum: General
- Topic: Routine for getting the count in the link
- Replies: 5
- Views: 2869
Routine for getting the count in the link
Can anybody share a subroutine which returns the count from the source stage link and to a target stage link and to a reject stage link. It is very urgent.
- Wed Dec 29, 2010 5:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Range Lookup
- Replies: 1
- Views: 1291
Range Lookup
1.I AM GETTING 3 COLUMNS FROM SOURCE (xx) P_TYPE S_TYPE POLICY_NUMBER. 2.I have 3 cols coming from reference(yy) p_type s_type product_code 3.I need to do this xx.p_type=yy.p_type and xx.s_type=yy.s_type and populate the product_code. 4.If the product_code is null then i need to look up on another (...
- Mon Dec 13, 2010 6:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Suurogate key generation in a database
- Replies: 2
- Views: 1426
Suurogate key generation in a database
Hi Folks I want to generate a surrogatekey directly in a table i mean neither using a flatfile nor using a database sequence.How is it possible and which properties i have to fill with what? say my colnume for surrogatekey is ID_NUMBER Number(25,0) PK and table name is TABLENAME. The efforts will be...
- Wed Dec 08, 2010 5:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: If the input column is in the last four months then X then Y
- Replies: 4
- Views: 2194