DSXchange

Hi SK If you want to load sumarize records from an oracle table you have two choices: 1) Using a sql sentences that sumarize and return the records agregatted and load or .. 2) Using the DataStage agregator to sumarize for the fiels that you needed, in this case you will need temporary space to calc...

Hi,

This link can help you

http://www.ascential.com/services/education.html

Hi, In my Job Templates defined in Manager, in the AllocatedFile there is a line that calculate the BLOCKSIZE // DCB=(LRECL=%reclen, BLKSIZE=%blocksize ,RECFM=%recfm) The real jcl in the 390 say DCB=(LRECL=306,BLKSIZE=3060,RECFM=FB) The DS is calculating the BlockSize = RecordLenght * 10 (records) C...

Hi,

In this case you have to use job mainframe to extract data from mainframe environment, so, you have to convert the binary data to character type and transfer it using ftp or connect to unix environment.

When you have the data in Unix you can use the job server (unix).

I hope this help.

In the last forum there was a choice to select the page number using a ListBox. This forum will implement this choice?

Arier,

In my job i see the next format

Field1 Pic S9(9) COMP

and must be

Field Pic 9(9) COMP

But my field is unsigned !! when the field format is signed is there a problem when try to read???

This is my question...

Hello, I'm developing job mainframes, the datatypes used are integer signed and unsigned, the problem is when define in DataStage the datatype as integer, but the default is signed, i need to define a integer unsigned.. Is there a problem when read a dataset using the incorrect datatype, in this cas...

Hi Kevin, You have the follow choices: 1) Kill the process from the Director option Cleanup resources 2) Restart the DataStage services. 3) Reboot the DataStage server. I recommend to you the first choice, if don't work continue with the next until unlock the job. Miguel Seclen Lima - Peru

Hi L.Duarte, You can make a routine with this code, you must to define arguments YourString = the string to format "MD3Z" = The number of decimals (3 is the number, if you want another value, change it) "9'0'R" = this is output format (9 is the long of the output string, 0 is the...

Why don't use a hashed file ?

Miguel Seclen
Lima - Peru

Hi Guillermo,

There isn't a function to create an array from string and viceversa, you must to implementate an algoritm to receive an string and create the array and viceverse..



Miguel Seclen
Lima - Peru

Hi, When i use a routine that connect an Oracle db using ODBC (the conection is defined in the .odbc.ini ) this message appear in the result of the routine.. " [MERANT][ODBC Oracle driver]You are not licensed to use this MERANT ODBC Driver under the license you have purchased. If you wish to pu...

Hi Kevin,

Check this last item ...

http://www.tools4datastage.com/forum/to ... ms=nextval


Miguel Seclen
Lima - Peru

Hi Myles...

All statements must be in one line, if you break the statement will have a compilation error..

Miguel Seclen
Lima - Peru

Hi Xiong, You must considerate the follow items: 1) The lookup table must to have a primary key (or index) with the statistics updated to improve performance lookup. 2) Don't use hashed files, is very hard to build a big file .. for the numbers of records will take many hours to create... 3) use the...