Page 1 of 1
datastage accelerator for datastage coding standards?
Posted: Fri Jun 23, 2017 4:04 am
by pkll
Hi All,
Do we have any idea how to build a data stage accelerator for data stage coding standards?
Thanks for advanced help...
Posted: Fri Jun 23, 2017 6:37 am
by chulett
You might want to explain a bit what that means in your world so people can provide better targeted answers...
Posted: Fri Jun 23, 2017 6:46 am
by pkll
We might need XMETA table names to fetch stage names,link names used as part of each jobs.And also jobs part of each sequence.
(based on the names given to each,we need to validate if required naming standards had been followed.)
Posted: Fri Jun 23, 2017 7:34 am
by UCDI
There is probably a better way, but I just parsed the extract file, found the stage and link names, compared them against the rules in our standards document, and spewed out a list of offending entries. Fairly short C program to do it.
Posted: Sat Jun 24, 2017 6:54 am
by Timato
If you have IGC - write a query (not a SQL query mind you - the query in the IGC interface) which can be exported as a CSV.