DSXchange

You need to first do all your transformation in transformer with all the XML path description in the output columns of transformer(manually) then input that to XML stage and select a "Single row" option in transformation settings. Now put just one column with a big varchar length in XML ou...

Sure I will let you guys know. Thanks to All.

Thanks Craig for the suggestion, just curious to know how it is related to database, I mean since we are dealing with datastage repository folders here
....not much familiar with XMETA.

Version is 8.0, and I am trying to reindex the datastage repository.

I tried executing DS.REINDEX ALL from Datastage administrator but its asking me File name :. Don't know what file name I need to provide..... Any ideas.

Did anyone happen to solve this issue ? I am facing the same

I used the below perl script found on dsxchange and testesd it. #!/usr/local/bin/perl -w ################################################################################################################### # # Documentation Header # ####################################################################...

Even I found that in 8.0 that when any jobs gets locked and if we try to clean up the resources it doesn't show the PID because it already unlocks it. If you wait for a while and open the job in designer, it will open fine.

Not sure if this is just an assumption.

Yes I do have..... I also found this dsx cutter perl script. Thinking of giving a shot on it.

viewtopic.php?t=88342&highlight=UPDATE+ ... 7RO\%27%3B

It was for 6 version. Doesn't work for me I believe.

Some one on the forum here suggested to update the ds objects to not read only by running Can anyone advise me on it, quite afraid to try it from Administrator

Thanks Craig for the response.

I can't find any option in GUI to include read-only object. When I open the export window from designer there is a check box which says exclude read only items, it looks like its already defaulted to include. May be I am looking at wrong place

How to include the read-only objects while exporting a job through command line ? It's giving a message that it omitted read-only objects.

Thanks in Advance.

Search the forum.

I believe join will handle the big volume..... can you post the exact SQL you r running on data stage and db2 client ?