DSXchange

Thanks for all the inputs. I have tested vmcburney's idea but it does not help. Row Merger concatanates all the cols irrespective of key cols or output tab cols.

I will try Kenneth's Idea...

Thanks again...

I want to concat some of the cols from a record into one single column. I was hoping to do this with row merger but it seems it will concat all the columns. I could not figure out a way to concat some of the cols. Basically I am trying to concat all the cols except key cols to find the CRC value for...

Thanks for the suggestion. However since we need to add those variables manually in dsenv file it makes maintenenace harder...I mean wenever we make changes to env variables in DataStage I need to changed it here too...which probabaly I can't sell in my company. Also If I decided to add them manuall...

Can anyone tell me how to access the DataStage environment variable values in server (Unix). I know that all of those Env variables does exist in DSParams file and I can access them If I start a shell script from DataStage. But I want to kick of a shell script which should access those variables. An...

Guys In one of the posts here, it's mentioned that we don't need to promote Table Definitions to other environment if we are just need to run the job in that environment rather changing it. Is that true ? Doesn't DataStage look for Table Defs in the repository when it runs the job ? On the other han...

All, I am exporting a project and importing into another project using import and export commands not using version control. Do I need to worry about the Project Names ? For Exampe, I have a Project called EXTDEV which is my Development Project which I export and import into a Project called EXTTST ...

Reddy you did not provide more information about your environment like what technique you are decied to go with ClearCase(CC) as there are base ClearCase and UCM. But Generally you have to have to export things out of DataStage(DS) and Import into CC where different baselines will be made like DVL, ...

I am not a Guru. But I can tell you what I know about DataStage and CleaCase as we are planning to implement it. This is mainly depends on what kind of methodology you are going to choose in ClearCase. I am not sure if you are planning to adopt UCM(Unified Change Management) which is out of box prod...

wow...what a quick reply. Thanks for the lightning reply and that too during 10.30 PM central time and I believe it's 9.30 for you...
This is the greatness of this forum...Hats of to you guys...

Thanks for all the inputs. I think I misstated what I wanted to say... It's a input sequential file stage not output. I was wondering If I can read more than one file using seq file stage in a single datastage job.I don't want to use folder stage or don't want to merge the files before reading them ...

Hi Can we use wildcards in the file name option of output sequential file stage ? I tried like this in file name /path/myfile*.txt It gives me error code as status = -1. I think this means it is not able to open the seq file. does the wildcards allowed in the file name ? Thanks for your inputs...

You can export individual table definitions as DSX and XML formats from datastage manager...To my knowledge you can't export as csv from manager...one morething is you can't export the individial table definitions from command line...

Rgds

Thanks Arnd and Craig... Try to search using the keyword " filter command ".... This is the original post I was talking about...posted by Craig on Tue Jun 07, 2005 11:52 am... ============ The Filter can take any O/S command that handles Standard In and Standard Out well. Sort should be on...

Hi

I read somewhere in this forum that filter commands truncates charecters when we use pipe symbol in version 7.1.

I am using version 7.5 and am facing the same problem.
Is this issue ever resolved ? If so do we need to install any patch for this ?

Please let me know.

Thanks

So there is no way we can see the SQL in the job log in Director ?

Thanks