DSXchange

Hi Santosh, you simple have to write a routine in DataStage, which does the work for you. Wolfgang Problem Description: There is a age field in CCYY-MM-DD format. I need to get the age field in months as numeric value. Like a person can have age like, 200 months or 525 months and so on so on so fort...

Write a litte VB or VBA programm, that transfers your spreadsheet data into a DB-Table (for example Access) make ODBC-connection to that DB.... Wolfgang I am presently working on Spreadsheet data to be loaded into a database.. I was able to successfully load a single sheet..for which i defined an od...

Hi, For this you could write a little Routine with 2 Parameters the first for the date and the second for the number of Month: First you have to be sure that your dateformat is allways like this. The you divide your string up: MyDay=MyDate[4,2] MyMonth=MyDate[1,2] MyYear=MyDate[4] Then you have to a...

Hi Santosh, If all your dates are in the way you showed you can devide the date in two partial strings: one for the year: MyYear=MyDate[4] and one for the Rest MyRest=Mydate[1,7] then you add one to the year: MyYear+=1 and you put the parts together: MyNewDate=MyRest:MyYear That's it! Wolfgang I am ...

Hi, what you are going to do is possible, but not the way you want to do it. There are two alternatives: (1) You remember all input in a common variable and then you put the stage after the writing stage and there you can write what was at last remembered. (2) You put your input in an intermedium Ha...

Hi, there is a version 4.2 and even 5.2 and soon there will be a 6.x. Go to the www.ascentialsoftware.com homepage for more details of the actual versions. Wolfgang Hi, I am kind of new to Datastage and I wanted to know what Datastage all of you are talking about. I have worked on Ardent Datastage v...

Hi All, While executing jobs with ODBC stages often I get the following 2 errors which I am unable to comprehend: 1)Invalid Cursor state. 2) SQL statement has incorrect number of result columns( this error occurs when I use a ODBC stage for Lookup) Please help me in understanding why these errors o...

Can someone please provide me with a list of commands you can use in the command path under data stage administrator ,and in short what they mean? Jan Moolman Hi Jan, you can use the UV-language which you can find in the uv-Manual on the cd or the standard sql-language which you find on the sql-man...

Put the Label, where you want to jump to in your code or if you don't need it leave it away. Wolfgang I wrote the following code: ReadSeq FileLine From CdrFileVar On Error Call DSLogWarn (" Error from " : " dwh/apps/ArdentFiles/cdr_sample.txt" : ", status : " :Status() ...

Nancy, for sure. But to tell you how, I need to know some more details about what you want to do. Wolfgang Thanks a lot for your help Do u have any idea how can I fill a sequential file in a job with the contents of a two dimensional array Hi Nancy, You can use even more than two dimensions in an ar...

Hello God, don't start before you have check the expierence from other and think about on migrating to 5.2., it is already available for a lot of platforms. And check every stage-Type you use. I've seen a lot of people changing with informing before and those had had a lot of problem after the migra...

Hi Angela, yes everybody who wants to write a serious DataStage-Application has to think about this before starting the project. And all those, who work already in project for sure have one. So simple ask DataStage-people you know, if they can share theirs with you, maybe for a lunch or two. Wolfgan...

Yes it is.
But it is a little bit easiar to call a programm out of a routine.

Where are you on? NT or Unix.

Wolfgang

i want to call a cobol(or a c) function from datastage in order to
use the result of this function
is it possible?

thanks

Hi Nancy, You can use even more than two dimensions in an array. Output is one value, but if you write a whole array in this one value you can pick out the more values by for example the field-Function. Hope that this will help you. Wolfgang Hi everyone, I was wondering does anyone knows if we can u...