Search found 1213 matches
- Sun Apr 03, 2011 7:41 pm
- Forum: General
- Topic: Waiting for job NoDependentJobs.JOBNAME to finish
- Replies: 4
- Views: 3281
Waiting for job NoDependentJobs.JOBNAME to finish
Hi All I created a Datastage Sequence Job. The aim of this job is to get the list of job names from a file and trigger the jobs it using loop activity stage unconditional. Job Design: Execute Command Activity --> StartLoop -->Job Activity -->EndLoop. Notes: Job Activity will trigger a server job; co...
- Mon Mar 28, 2011 7:44 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to check whether the file exist or not
- Replies: 4
- Views: 2940
I will close it
Thanks Ray
I will close the file. But is it the only way to find the file? Any other command is there to check?
Regards
DS User
I will close the file. But is it the only way to find the file? Any other command is there to check?
Regards
DS User
- Mon Mar 28, 2011 6:28 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Server Routine to check whether the file exist or not
- Replies: 4
- Views: 2940
Server Routine to check whether the file exist or not
Hi All Need: I need to know whether a file is exist in a specific dir. If exist i need to create a .ok file. Is there is any way to do or Can try to open the file like below and if the below command is suceed, then i can create a .ok file. SeqFiles = File Path OpenSeq SeqFiles: aFileName TO Jname Pl...
- Fri Mar 25, 2011 5:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
- Replies: 8
- Views: 7904
Is this the word "NULL" or a true NULL ?
Hi Ray
It may be NULL and not "NULL". The reason is; It is the retrun value of the Stored procedure (170|NULL|NULL|1).
Thanks
DS User
It may be NULL and not "NULL". The reason is; It is the retrun value of the Stored procedure (170|NULL|NULL|1).
Thanks
DS User
- Thu Mar 24, 2011 10:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
- Replies: 8
- Views: 7904
Re: Ereplace is working
Hi Ray / craig Apoligies for marked it as resolved. Now i am getting the value concatenate with NULL and i fails to notice it in time. 170|9999-12-31NULL|NULL|1 A = Field ( out, ' ', 1) B = Field( out, ' ', 2) C = Field ( out, ' ', 3) D = Field ( out, ' ', 4) Rtn = Trim (A) : '|' : Ereplace(Trim (B)...
- Thu Mar 24, 2011 10:21 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
- Replies: 8
- Views: 7904
Ereplace is working
Hi Ray / craig
I tried with Ereplace and it is working fine.
Thanks for your time and guidance,
DS User
I tried with Ereplace and it is working fine.
Thanks for your time and guidance,
DS User
- Thu Mar 24, 2011 5:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
- Replies: 8
- Views: 7904
NullToValue
Hi Ray Thanks for your reply. As per the logic, sometime it may return NULL value for DATETIME column from the Stored Procedure. In that case, can i able to use NullToValue (field(GetIDs.$ReturnValue, '|' ,2) ,'9999-12-31') ? - (I will try to use like this) Or the procedure need to return the value ...
- Wed Mar 23, 2011 10:01 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
- Replies: 8
- Views: 7904
Error calling DSSetParam(ST_DATE), code=-4 [ParamVal]
Hi I am getting a return value from a Server Routine as 170|NULL|NULL|1 170 - INT NULL - DATETIME NULL - DATETIME 1 - INT I am going to use these values as a PARAMETER to load into SQL Server. In the job activity stage i used the below code and getting error "Error calling DSSetParam(ST_DATE), ...
- Sun Mar 20, 2011 9:40 pm
- Forum: General
- Topic: Execute a Server Routine to connect SQL Server Database
- Replies: 1
- Views: 3054
Re: Execute a Server Routine to connect SQL Server Database
Hi All Issue resolved. The way how i passed the value into the sqlcmd is the problem and found it. The below code is working fine. 'sqlcmd -S ServerName -U UserName -P Password -d DBName -Q "SET NOCOUNT ON DECLARE @ID INT EXECUTE dbo.ProcedureName InputValue, @ID OUTPUT SELECT @ID"' In the...
- Thu Mar 17, 2011 10:25 pm
- Forum: General
- Topic: Connecting to Sql server 2008 from Server routine
- Replies: 24
- Views: 17202
- Thu Mar 17, 2011 9:35 pm
- Forum: General
- Topic: Execute a Server Routine to connect SQL Server Database
- Replies: 1
- Views: 3054
Execute a Server Routine to connect SQL Server Database
Hi All I written a Server Routine to execute a SQL Stored procedure and it is working fine, but when i execute the same routine using Routine Activity, getting problem. Herewith the Routine code: SQLSTMT = 'sqlcmd -S' :SERVER:' -U ':UNAME:' -P ':PWD:' -d R_Ctrl' : ' -Q ':SQLFILE:' -h -1 -m 1 -W' cal...
- Sun Mar 13, 2011 6:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job hangs on Parallel execution mode
- Replies: 1
- Views: 3834
SQL Server 2008 R2 is not a supported version for 8.1
Hi All
Found the result for this issue.
SQL Server 2008 R2 is not a supported version for 8.1 Information Server.
Confirmed with IBM.
Regards
DS User
Found the result for this issue.
SQL Server 2008 R2 is not a supported version for 8.1 Information Server.
Confirmed with IBM.
Regards
DS User
- Thu Mar 10, 2011 7:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job hangs on Parallel execution mode
- Replies: 1
- Views: 3834
Datastage job hangs on Parallel execution mode
Hi All I had a chance to look into Datastage job issue. ISSUE: Job is simply hanging. (Some day this job will not give any issue) Job Design: Seq file --> TFM --> SQL Server Enterprise stage (Append mode). When i ran the job it is simply in running status in Datastage. In SQL Server the query went t...
- Sun Feb 27, 2011 11:58 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job hangs after main_program: orchgeneral: loaded;
- Replies: 2
- Views: 4865
Something happened on that time in Database level
I understood the query is suspended as per the log in Database. But no one did it and it happened for some reasons I guess. I will investigate in detail and update the status.
Thanks
DS_User
Thanks
DS_User
- Sun Feb 27, 2011 5:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage job hangs after main_program: orchgeneral: loaded;
- Replies: 2
- Views: 4865
Datastage job hangs after main_program: orchgeneral: loaded;
Datastage job hangs after main_program: orchgeneral: loaded; A simple Datastage job: Read the data from SQL server and write (Truncate and insert) into SQL server. SQL Server Enterprise Stage --> Transformer --> SQL Server Enterprise Stage is the job design. It is running for more than 24 hrs and no...