How to get negative values from sequencial file csv format? datastage Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern) Data science time! April 2019 and salary with experience The Ask Question Wizard is Live!DataStage DB2 Runtime Column Propagation with Unicode Datausing schema files with decimals for datastage file sequence importHow to determine existence of overlaps in Zip Code ranges (DataStage 8.5)Splitting DataStage Output based on Key Columnhow to pass Empty string string into a xml file using Datastage?Stages to remove repeated value from a file in datastageDecimals are displaying with out rounding offDataStage: run low level socket connectionDATASTAGE replace values in csv file.schema file datatype alternative for PostgreSQL numeric column datatype
Amount of permutations on an NxNxN Rubik's Cube
What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?
Can the Great Weapon Master feat's damage bonus and accuracy penalty apply to attacks from the Spiritual Weapon spell?
Why do early math courses focus on the cross sections of a cone and not on other 3D objects?
Performance gap between vector<bool> and array
How do I find out the mythology and history of my Fortress?
Generate an RGB colour grid
Can anything be seen from the center of the Boötes void? How dark would it be?
Did Krishna say in Bhagavad Gita "I am in every living being"
Why does the remaining Rebel fleet at the end of Rogue One seem dramatically larger than the one in A New Hope?
Has negative voting ever been officially implemented in elections, or seriously proposed, or even studied?
How much damage would a cupful of neutron star matter do to the Earth?
Why is Nikon 1.4g better when Nikon 1.8g is sharper?
Trademark violation for app?
What is "gratricide"?
How do living politicians protect their readily obtainable signatures from misuse?
Illegal assignment from sObject to Id
How to react to hostile behavior from a senior developer?
Dating a Former Employee
Is there any word for a place full of confusion?
Chinese Seal on silk painting - what does it mean?
Project Euler #1 in C++
How could we fake a moon landing now?
Putting class ranking in CV, but against dept guidelines
How to get negative values from sequencial file csv format? datastage
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 23, 2019 at 00:00UTC (8:00pm US/Eastern)
Data science time! April 2019 and salary with experience
The Ask Question Wizard is Live!DataStage DB2 Runtime Column Propagation with Unicode Datausing schema files with decimals for datastage file sequence importHow to determine existence of overlaps in Zip Code ranges (DataStage 8.5)Splitting DataStage Output based on Key Columnhow to pass Empty string string into a xml file using Datastage?Stages to remove repeated value from a file in datastageDecimals are displaying with out rounding offDataStage: run low level socket connectionDATASTAGE replace values in csv file.schema file datatype alternative for PostgreSQL numeric column datatype
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
Am taking information from a csv file, one of the columns have negative values, when I get the information in datastage and insert into a table in teradata the negative values dont have the negative simbol like a negative, instead appear a dash. For this reason at the moment to cast to decimal is not possible.
transform datastage
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
add a comment |
Am taking information from a csv file, one of the columns have negative values, when I get the information in datastage and insert into a table in teradata the negative values dont have the negative simbol like a negative, instead appear a dash. For this reason at the moment to cast to decimal is not possible.
transform datastage
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36
add a comment |
Am taking information from a csv file, one of the columns have negative values, when I get the information in datastage and insert into a table in teradata the negative values dont have the negative simbol like a negative, instead appear a dash. For this reason at the moment to cast to decimal is not possible.
transform datastage
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
Am taking information from a csv file, one of the columns have negative values, when I get the information in datastage and insert into a table in teradata the negative values dont have the negative simbol like a negative, instead appear a dash. For this reason at the moment to cast to decimal is not possible.
transform datastage
transform datastage
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
asked Mar 8 at 20:20
kevin vargaskevin vargas
1
1
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36
add a comment |
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36
add a comment |
1 Answer
1
active
oldest
votes
You can try selecting the field type as varchar in the .csv stage. This will generate an warning but the value will be pulled in. Later you can do necessary conversion.
Or you can see if in your unix environment you can convert that file to sequential file.
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55070468%2fhow-to-get-negative-values-from-sequencial-file-csv-format-datastage%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You can try selecting the field type as varchar in the .csv stage. This will generate an warning but the value will be pulled in. Later you can do necessary conversion.
Or you can see if in your unix environment you can convert that file to sequential file.
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
add a comment |
You can try selecting the field type as varchar in the .csv stage. This will generate an warning but the value will be pulled in. Later you can do necessary conversion.
Or you can see if in your unix environment you can convert that file to sequential file.
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
add a comment |
You can try selecting the field type as varchar in the .csv stage. This will generate an warning but the value will be pulled in. Later you can do necessary conversion.
Or you can see if in your unix environment you can convert that file to sequential file.
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
You can try selecting the field type as varchar in the .csv stage. This will generate an warning but the value will be pulled in. Later you can do necessary conversion.
Or you can see if in your unix environment you can convert that file to sequential file.
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
answered Mar 18 at 17:39
Sourabh BanerjeeSourabh Banerjee
1
1
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55070468%2fhow-to-get-negative-values-from-sequencial-file-csv-format-datastage%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Which data type have you defined reading the csv for that column? Try decimal there so it get interpreted right away.
– MichaelTiefenbacher
Mar 9 at 11:36