DSXchange

Hi Kenny, I remembered over the weekend - there was a problem with the job compiler interfering with schedule information if you recompile after a schedule item has been set. We fixed it under ecase 36053. Regards - Chris Thornton -----Original Message----- From: Salstrom, Kenneth [mailto:Kenneth.Sa...

Chris, I havent tried Ascential support yet. I figured that Id try the list first. Thanks, Kenny -----Original Message----- From: chris.thornton@ascentialsoftware.com [mailto:chris.thornton@ascentialsoftware.com] Sent: Friday, October 18, 2002 10:48 AM To: datastage-users@oliver.com Subject: RE: JOB...

Hi Kenny, The missing record relates specifically to scheduling the job. This explains why it works fine when you run it manually. Have you tried contacting Ascential support with this problem? Regards - Chris Thornton -----Original Message----- From: Salstrom, Kenneth [mailto:Kenneth.Salstrom@msnyu...

Hi Kenny, Check if you have exceed the t30 files limited. You can do it with : smat -d this will list all T30 files that you have opened at this moment, normally the limit is 200, see if you had exceed it. best regards Rui Soares Rui Miguel Soares NOVABASE - Business Intelligence Mail : Rui.Soares@N...

I moved some changes into Production last night. The jobs were compiled and validated. When it attempted to run this morning it failed with the error DS.SCHED: Cannot find record JOBPARAMINSTS in executable job file RT_CONFIG610 When I ran the job manually it worked. I couldnt find this error in the...

Go to the folder where you installed DataStage client. By default this is C:Program FilesAscentialDataStage. Under this location is a folder called Docs, in which you will find the DataStage manuals. The one youre after is BASIC.pdf, and the SEEK statement is on page 6-520. ----- Original Message --...

Thanks! "Shawn Ramsey" cc: Subject: RE: Pivot stage 10/17/2002 04:29 PM Please respond to datastage-users There is a PDF document on the DataStage CD that explains how it works. But essentially it will take columns data and make a row for each column repeating the key columns. -----Original Message-...

There is a PDF document on the DataStage CD that explains how it works. But essentially it will take columns data and make a row for each column repeating the key columns. -----Original Message----- From: lfrumke@sears.com [mailto:lfrumke@sears.com] Sent: Thursday, October 17, 2002 2:15 PM To: datas...

Hi,

I am trying to find any documentation about the Pivot stage. How does it actually work?

Thank you,
Leonid Frumker

FYI, > The error message "Unable to allocate Type 30 descriptor, table is > full" means that T30FILE parameter is set too low. T30FILE specifies > the number > of dynamic files that can be open per system wide. > > The default value is 200. > > To raise this parameter, please do the following. > > 1...

Sorry, but this change the job information is wrong. The create option in the Hash file stage only creates the hash if it doesnt already exist. It doesnt make any sense to add an option that you need to set, run once, then go back and unset and recompile before you can run it again. As best as I can...

Hello Mario, the folder stage has only 2 columns (1. FileName, 2. Record (content of the file)). Load Column Definition from Build-InExamplesFolder. Regards Udo "Dudley, Mario M" 16.10.02 23:43 Bitte antworten an datastage-users An: "datastage-users@oliver.com" Kopie: Thema: Folder stage Im trying t...

The folder stage reads file within a directory, with each file found corresponding to one row passed out of the stage. The row can have 1 or 2 columns. One is for the name of the file, the other for its content, as a single string. If there are 2 columns, one must be marked as a key column and one n...

You can check that you have an eight numeric digit string by testing Is8Num = (String Matches "8N") You can check that the string is a valid date in YMD order by applying an Iconv() function specifying that this format is required, then testing the result returned by the Status() function. Check = I...

OpenSeq pathname To filevariable On Error GoSub FileError End Locked GoSub FileError End Then Seek filevariable,0,2 Then * positioned at end of file ready to write End Else GoSub SeekError End ; * end of Seek statement End Else If Status() = 0 Then * positioned at end of file ready to write * file d...