Search found 233 matches
- Thu Feb 22, 2018 2:30 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How Pivot Stage works in Server Edition of Datastage 11.5
- Replies: 3
- Views: 14857
Re: How Pivot Stage works in Server Edition of Datastage 11.
You can do this by defining stage variables, sorting the data on the key column and concatenate the 2nd column
- Thu Feb 22, 2018 12:31 pm
- Forum: General
- Topic: List the sequencers which uses environmental variable
- Replies: 2
- Views: 2585
List the sequencers which uses environmental variable
Hello, I am trying to list all the sequencer jobs that uses the FTP_EPSILON_HOST user defined environmental variable. I asked the Admin to run the below command but it did not list any sequecers even though we have many jobs. DS_JOBS WITH JOBTYPE = 2 AND EVAL "TRANS('DS_JOBOBJECTS','J\':@RECORD...
- Thu Nov 09, 2017 5:08 pm
- Forum: General
- Topic: list of jobs using a certain environmental variable
- Replies: 1
- Views: 2445
list of jobs using a certain environmental variable
Hello,
Can you please let me know how I can list all the jobs that uses a certain environmental variable in a project.
Thanks
Can you please let me know how I can list all the jobs that uses a certain environmental variable in a project.
Thanks
- Tue Nov 01, 2016 3:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Accessing of Bluemix Biginsights using On-Prem Datastage App
- Replies: 0
- Views: 2457
Accessing of Bluemix Biginsights using On-Prem Datastage App
Hi, I am trying to access the IBM Bluemix cloud Biginsights (HDFS) files using Datastage 11.5 - File connector stage(webhdfs) which is in on-prem computer. I have set up the biginsights in bluemix.But the connection is failing with the on-prem datastage application. I have brought the SSL certificat...
- Sat Oct 08, 2016 10:49 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hive error: java.sql.SQLException: Only AEQuery is supported
- Replies: 2
- Views: 3588
Urgent Help needed!
Can anyone please help me out on above request...Thanks in advance
-Sharath
-Sharath
- Fri Oct 07, 2016 1:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Hive error: java.sql.SQLException: Only AEQuery is supported
- Replies: 2
- Views: 3588
Hive error: java.sql.SQLException: Only AEQuery is supported
I am trying to load data to Hive table using JDBC Connector stage. Connection is established and I am able to view the data from the table but when the insert statement is executed job is failing with the below error. MSG ID: <IIS-CONN-JDBC-00009> JDBC_Connector_14,1: Fatal Error: The connector fail...
- Mon Oct 03, 2016 4:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while connecting to HDFS
- Replies: 3
- Views: 5808
Re: Issue while connecting to HDFS
Can anyone please help me out on this...It's urgent
- Fri Sep 30, 2016 11:53 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue while connecting to HDFS
- Replies: 3
- Views: 5808
Issue while connecting to HDFS
Hi, I am getting below errors while trying to connect to HDFS through datastage using any stage like BDFS,HDFS File connector, File Connector. Error 1: main_program: Fatal Error: Failed to read data from Application Master sending YARN resource information. Check the health of YARN/Hadoop. Socket er...
- Wed Jan 27, 2016 4:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion from 1/1/2014 to 2014-01-01
- Replies: 3
- Views: 3111
- Wed Jan 27, 2016 4:20 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Date conversion from 1/1/2014 to 2014-01-01
- Replies: 3
- Views: 3111
Date conversion from 1/1/2014 to 2014-01-01
Hello,
I am trying to convert 1/1/2014 to 2014-01-01. Any suggestions. I tried this but output to file has all ***
DatetoString(stringtodate(DSLink9.DT,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")
Thanks
I am trying to convert 1/1/2014 to 2014-01-01. Any suggestions. I tried this but output to file has all ***
DatetoString(stringtodate(DSLink9.DT,"%mm/%dd/%yyyy"),"%yyyy-%mm-%dd")
Thanks
- Wed Jun 24, 2015 9:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading large record in to teradata table
- Replies: 10
- Views: 12246
- Mon Jun 22, 2015 8:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading large record in to teradata table
- Replies: 10
- Views: 12246
Thanks for the reply. 1. Yes i am aware of the limitation on the bulk mode. 2. Yes i did use the APT_DEFAULT_TRANSPORT_BLOCK_SIZE ENV variable with default value 1280000 3. I also used APT_TSORT_STRESS_BLOCKSIZE with default value as 3000000 as per IBM link below. 4. The buffer side i tried using a)...
- Sun Jun 21, 2015 8:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading large record in to teradata table
- Replies: 10
- Views: 12246
1. I am using Teradata connector stage 2. I am using immediate option with array size 1. bulk option is not working. 3. write mode: Insert 4. Table action: Append 5. Record count 100 6. Enable lob references: NO 7. The target column that i have issue is defined as clob. I am able to insert filed les...
- Sat Jun 20, 2015 8:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading large record in to teradata table
- Replies: 10
- Views: 12246
- Sat Jun 20, 2015 8:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: loading large record in to teradata table
- Replies: 10
- Views: 12246