DSXchange

And certainly never warranted three exclamation points.

But thats the one thing which i felt missing in DSXCHANGE compared to old developernet. Its surely a 'good to have ' feature. Don't know if it was discussed before.

You can also use the Function. you may need to handle the possibility of nulls in input field.

You can keep the output column as data type Integer.



You can also use a modify stage with conversion specification using

If i remember right the old ascential developernet site had a file upload area where lots of sample code and examples were uploaded, would be nice if we have something similar on dsxchange too.

Thanks
Ramesh

Hi ramesh, Could you please send me the stored proc for the same.

, well no commercial engagements yet ..i could also post the 'dsx' or job report on dsxchange if there was place to upload it.

At DSXchange we dont guarantee that solutions to problems will be given , helpful suggestions and hints are somethings that you can look for, i can however send you a dsx file for a vertical pivot operation that is only slightly different from your case-provided you give me your email id. Writing a ...

easier to process using rdbms stored procedures.

we used an after job script with ssh to to move a file across a secure network connection. You need to know how to create and use ssh. I had a document ,but i have lost it now..

System Variables[@ variables] (Server jobs)are documented in the BASIC guide, Parallel job environment variables are documented in the advpx.pdf ( as noted before it is the parallel job advanced developers guide)

SQL override Sounds like an ex-Informatica developer ;) You can also use a command activity stage that echoes a particular line in the file - using a combination of cat /echo/awk and subsequently use the Command.Output as the parameter value for the second job if the file has multiple lines, then y...

Any such design is highly sensitive to the context, no straightforward support exists for metadata that is dynamic (at least as as i know).

This is what the server job developers guide has to say about listing projects ( Page 709/776) through command line .. Listing Projects The dsadmin command can be used for listing the projects on a server. dsadmin -listprojects Lists all the projects on the server. Marking a question as "urgent...

Does any of your jobs within the sequence call Operating System commands( Before/After job commands)? I had similar issues, on resetting the individual job i found a lot of information that i did not understand - perhaps DSD_RUN PHANTOM ( i have posted the specific information sometime back)..

http://www.textpad.com/add-ons/files/syntax/datastagebasic.zip Highlight your UV code and make it easier to read/understand- works with TextPad- you can see the code in your favorite fonts rather than ugly Courier(Screen font). Copy the syntax file to the syntax sub directory in your text pad instal...

In older versions i would have suspected a view like entity created in Universe, considering the server job context. In case you refer to a view created in a database, then you can have a Before SQL that creates/populates a view or a materialized view , import its column definition to the source sta...

MsPink - We are all none the wiser - with fancy user created terminology - can you explain the problem statement and its context in greater detail- database view or datastage view- can you let me know where in the documentation of v8 is something called 'datastage view' documented? If so then me or ...