Search found 40 matches
- Mon Dec 04, 2017 7:33 pm
- Forum: General
- Topic: Issue running job using dsjob in command line
- Replies: 3
- Views: 2442
Issue running job using dsjob in command line
I have a simple DS job and I am trying to run it from the command line using DS job as below but it is not running. Both client and server are installed on the same machine on which I am trying to run. Please advise. Command used: D:\IBM\InformationServer\Server\DSEngine\bin>dsjob -run -jobstatus pr...
- Fri Jan 27, 2017 1:18 pm
- Forum: General
- Topic: Running Cognos Turbo Integrator process using Datastage
- Replies: 0
- Views: 2193
Running Cognos Turbo Integrator process using Datastage
Does anybody have experience running the Cognos TI process from Datastage and how to do it? I know there is a Cognos TM1 Connector in Datastage. As per my analysis, that is only used for reading and writing the data from/to Cognos TM1 Cubes/Dimensions/Views. Please let me know if my understanding is...
- Fri Nov 25, 2016 7:37 pm
- Forum: General
- Topic: How to get previous month in the sequence/Basic language
- Replies: 2
- Views: 4020
How to get previous month in the sequence/Basic language
I am passing parameters to a Job activity in the sequence. I have two parameters current month (YYYYMM format) and previous month (YYYYMM) format. Is there a way to derive previous month from the current month (preferably in the Value Expression section of the Job Activity)?
Please suggest.
Please suggest.
- Fri Nov 25, 2016 7:23 pm
- Forum: Cognos (IBM BI)
- Topic: Automated analysis/migration of Cognos Data Manager jobs
- Replies: 3
- Views: 18089
I am in the same boat. In my case, most of the data manager jobs have transformation logic in source SQL itself. As per my research, there is no way to convert the SQL into datastage jobs using stages. Hence I am developing datastage jobs by copying the SQLs to ODBC connector stage with User-defined...
- Fri Nov 25, 2016 7:17 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Access remote file from Sequential Stage
- Replies: 5
- Views: 5902
- Wed Nov 16, 2016 4:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job parameters in user defined SQL
- Replies: 5
- Views: 5026
- Tue Nov 15, 2016 3:34 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job parameters in user defined SQL
- Replies: 5
- Views: 5026
FYI, I am seeing the generated SQL in the log and it is correct. as below:
But I don't know which is the invalid character
Code: Select all
Insert into schema.Table_name (
Column1,
Column2)
(select clm1,
Case when 0=0 Then 'Clm2'
Else 'Test' End Colm2
From Table2)
- Tue Nov 15, 2016 3:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Job parameters in user defined SQL
- Replies: 5
- Views: 5026
Job parameters in user defined SQL
I am trying to run user defined SQL in ODBC stage. The query is as below: Insert into schema.Table_name (Column1, Column2) (Select Clm1, Case when #Param2#=0 Then 'Clm2' Else 'Test' end as Colm2 From Table2) Note: Param2 is a job parameter But I am seeing below error ODBC function "SQLExecute&q...
- Mon Nov 07, 2016 3:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading files using File Pattern
- Replies: 3
- Views: 3242
- Wed Nov 02, 2016 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error reading files using File Pattern
- Replies: 3
- Views: 3242
Error reading files using File Pattern
I am reading multiple csv files using Sequential File Stage with File Pattern option. But while reading Datastage is concatenating last record of first file and first record of second file. I think that is because there is no new line character after the last record of first file. How can we address...
- Thu Oct 27, 2016 11:40 am
- Forum: General
- Topic: Issue parsing parameter from server routine
- Replies: 4
- Views: 3330
- Wed Oct 26, 2016 6:16 pm
- Forum: General
- Topic: Issue parsing parameter from server routine
- Replies: 4
- Views: 3330
Thanks Craig. I did check the other posts related to this and they said it was the issue with the datatype of the parameter defined in the job. I have defined it as String. Since my routine is returning AUG-16 it should be accepted in the job. This is where I am getting confused and want to know if ...
- Wed Oct 26, 2016 4:18 pm
- Forum: General
- Topic: Issue parsing parameter from server routine
- Replies: 4
- Views: 3330
Issue parsing parameter from server routine
I have written a server routine for executing the SQL and returning the result as below (by taking a post from this forum as ref): *Write query to a temporary sql file. cmd= "echo ":Query_File: "> G:\temp\Datastage\Query.sql" Call DSExecute("NT",cmd,Output,Retval) *exec...
- Mon Oct 24, 2016 6:24 pm
- Forum: General
- Topic: Datastage routine for running SQL
- Replies: 2
- Views: 3218
Datastage routine for running SQL
I have created a datastage server routine to run SQLs by taking the below post as a reference: http://www.dsxchange.com/viewtopic.php?p=351611 My routine is: *Write query to a temporary sql file. cmd= "echo SELECT TO_CHAR(TO_DATE('201608','YYYYMM'),'MON-YY') FROM DUAL; > G:\temp\Datastage\Query...
- Mon Oct 24, 2016 5:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Running SQL statements in datastage
- Replies: 7
- Views: 7612